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 > JDBC > Plan for adapter implementation
Support for prepared statement caching
IBM WebSphere Adapter for JDBC 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 Process Administrative Console to set the DatasourceJNDIName property for inbound processing
- Using the Process Administrative Console to set the poolDataSourceJNDIName or the XADataSourceJNDIName property for outbound processing