4 Replies Latest reply: Feb 28, 2013 11:29 AM by user11988534 RSS

    java.sql.SQLException: Connection Cache with this Cache Name is DisabledDS

    951697

      We are getting error in connection pool for

      java.sql.SQLException: Connection Cache with this Cache Name is Disabled
      at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:331)
      at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:395)
      at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179)
      at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:157)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource$2.run(WSRdbDataSource.java:2194)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)

      Caused by: java.sql.SQLException: Connection Cache with this Cache Name is DisabledDSRA0010E: SQL State = 99999, Error Code = 17,142
      at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:331)
      at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:395)
      at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179)





      Here is our websphere side of config
      Configurations on Websphere side:

      JDBC Provider:

      Classpath:
      /u01/app/oracle/product/11.2.0.2/client_1/jdbc/lib/ojdbc6.jar
      /u01/app/oracle/product/11.2.0.2/client_1/opmn/lib/ons.jar

      NativeClasspath:
      /u01/app/oracle/product/11.2.0.2/client_1/jdbc/lib

      implementation class:
      oracle.jdbc.pool.OracleDataSource

      Datasource configurations:

      DB URL:
      jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orass0003.uhc.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=orass0002.uhc.com)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES))(CONNECT_DATA=(SERVICE_NAME=b2cst03svc.uhc.com)))

      Data store helper class:
      com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
      Custom properties:
      disableWASConnectionPooling true
      connectionCachingEnabled true
      fastConnectionFailoverEnabled true
      ONSConfiguration nodes=orass0003:6200,orass0002:6200 (also did try nodes=orasvcdbsls0036:6200,orasvcdbsls0037:6200,orasvcdbsls0031:6200,orasvcdbsls0032:6200 )
      connectionCacheName MyCache
      removeExistingOracleConnectionPoolIfExists true

      Connection pool size:
      min/max = 1/0