IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Plan for adapter implementation
Support for prepared statement caching
WebSphere Adapter for Oracle E-Business Suite supports prepared statement caching by the server, which can reduce the time required to perform an outbound or inbound operation or a batch of operations.
The adapter uses prepared statements, which are Java™ objects containing an SQL QUERY statement that is compiled once, but can be run multiple times. The server caches prepared statements to optimize their handling. If you want to use prepared statement caching for the adapter, define a data source using the Process Administrative Console, and enable caching on the data source. Then configure the adapter to use the data source, using one of these methods:
- Using the external service wizard when you initially configure the adapter to use the JNDI name of the data source
- Using the administrative console of IBM BPM or WebSphere Enterprise Service Bus to set the DatasourceJNDIName property for inbound processing
- Using the administrative console of IBM BPM or WebSphere Enterprise Service Bus to set the poolDataSourceJNDIName or XADataSourceJNDIName property for outbound processing