[AIX HP-UX Linux Solaris Windows]

Configuring Oracle connection caching in the application server

You can elect to configure an Oracle data source to use Oracle's connection caching feature instead of using the application server's connection pooling. Connection caching for Oracle databases is similar to connection pooling in the application server.

About this task

Currently, Oracle only supports connection caching with data sources that use the oracle.jdbc.pool.OracleDataSource implementation class, instead of the oracle.jdbc.pool.OracleConnectionPoolDataSource or oracle.jdbc.xa.client.OracleXADataSource classes. By default, the Oracle JDBC providers in the application server are configured to use the oracle.jdbc.pool.OracleConnectionPoolDataSource for non-XA data sources, or oracle.jdbc.xa.client.OracleXADataSource for XA data sources. To enable Oracle connection caching, you must configure and use a new JDBC provider in the application server that implements the oracle.jdbc.pool.OracleDataSource class.
Avoid trouble Avoid trouble: Oracle connection caching does not support XA.gotcha

Procedure

  1. Create a data source and user-defined JDBC provider.
    1. Click Resources > JDBC > Data sources
    2. Select a server from the Scope drop-down list.
    3. Click New.
    4. Enter the name and JNDI name for the data source. Click Next.
    5. Create a new JDBC provider. Select Create new JDBC provider, and click Next.
    6. Define the required properties for the JDBC provider. Use the following configuration settings:
      • Database type: User-defined
      • Implementation class name: oracle.jdbc.pool.OracleDataSource
      Click Next.
    7. Enter the class path for ojdbc6.jar, and click Next.
    8. For Data store helper class name, enter com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper. Click Next.
    9. Define the security aliases for this data source, and click Next.
    10. Finish the wizard.
    11. Save the configuration changes.
  2. Configure the data source that you created.
    1. Click the name of the data source. You will be taken to the configuration panel.
    2. Select Custom properties, and create or modify the properties for this data source. Enter or update the following custom properties:
      Name Value
      disableWASConnectionPooling true
      Avoid trouble Avoid trouble: You must also set the maximumPoolSize attribute to '0' on WebSphere Application Server connection pool settings to allow Oracle to control the pool boundaries.gotcha
      connectionCachingEnabled true
      connectionCacheName your_cache_name
      removeExistingOracleConnectionPoolIfExists true
      Avoid trouble Avoid trouble: The removeExistingOracleConnectionPoolIfExists property must be set to true so the application server will remove any existing Oracle connection pools with an identical name. Otherwise, the Oracle data source will fail the getConnection method if the pool name that is created has a name that is identical to an existing pool.

      For example, if you run a test connection, the test connection process will create an Oracle connection pool that will prevent the application server from working properly at run time.

      gotcha
      URL Oracle_URL
      Avoid trouble Avoid trouble: The order in which the custom properties are set is important. This could be an issue, as the application server passes the properties as a collection and the order is not guaranteed. If you encounter this issue, contact Oracle and reference Oracle bug #6638862.gotcha
  3. Click Apply or OK.
  4. Save the changes to the application server's configuration.
  5. Restart the application server.

Results

Be aware that Oracle will not display a message if the pool creation fails, and a normal connection will be returned instead. You can confirm that the connection pool is created by running your application, and try to issue a test connection. If the Oracle connection pool was created successfully, the test connection will fail with an exception that the Oracle pool name is already used. Therefore, you must create the data source and JDBC provider at the server scope.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 31, 2013 2:56:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-dist&topic=tdat_oracleracconnpool
File name: tdat_oracleracconnpool.html