This discussion is archived
4 Replies Latest reply: Feb 28, 2013 9:29 AM by user11988534 RSS

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

951697 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points