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

-
Error :-

JDBC Connection; nested exception is java.sql.SQLException: Connection Cache with this Cache Name is Disabled
Caused by:
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connection Cache with this Cache Name is Disabled
Caused by:
java.sql.SQLException: Connection Cache with this Cache Name is Disabled
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:310)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:286)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:159)

Symptoms :- Application wont work and giving above error

Cause :- Not able to recieve jdbc connection from the database.

Solution :- 1. Check DB & Listener is up and running (For me, listener was down)
2. Refresh the connection pools
3. Last Resort , restart the application server
4. Check the application , it will start working.

Comments

Post a Comment

Popular posts from this blog

Identity Service Authentication failure

-
Identity Service Authentication failure --2010-01-14 10:34:33,032-- --ERROR-- --oracle.bpel.services.workflow-- --::-- Identity Service Authentication failure. Identity Service Authentication failure. Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable. ORABPEL-10528 Identity Service Authentication failure. Identity Service Authentication failure. Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable. at oracle.tip.pc.services.identity.jazn.xml.XMLAuthenticationService.authenticateUser(XMLAuthenticationService.java:150) at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.authenticateUser(XMLIdentityService.java:426) at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:341) 1) Check username/password used in worklist is correct or not. 2) Add correct password in the descriptor of BPEL Process throwi...
Read more

Weblogic server is not starting up ; java.lang.AssertionError

-
  If the weblogic server is not starting up and giving the below error , please follow the below solution :- Error :- #Aug 18, 2014 12:34:29 AM PDT# #Notice# #WebLogicServer# #BEA-000365# #Server state changed to STARTING# #Aug 18, 2014 12:34:29 AM PDT# #Info# #WorkManager# #BEA-002900# #Initializing self-tuning thread pool# #Aug 18, 2014 12:34:29 AM PDT# #Notice# #Log Management# #BEA-170019# #The server log file /u01/app/oracle/config/domains/Vinay/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.# #Aug 18, 2014 12:34:29 AM PDT# #Critical# #WebLogicServer# #BEA-000386# #Server subsystem failed. Reason: java.lang.AssertionError: Could not obtain the localhost address. The most likely cause is an error in the network configuration of this machine. java.lang.AssertionError: Could not obtain the localhost address. The most likely cause is an error in the network configuration of this machine.   ...
Read more

jstatd error : Could not create remote object : access denied (java.util.PropertyPermission java.rmi.server.ignoreSubClasses write)

-
While running "./jstatd -J-Djava.security.policy=jstatd.all.policy &" command , below error is getting encountered Error :- Could not create remote object access denied (java.util.PropertyPermission java.rmi.server.ignoreSubClasses write) java.security.AccessControlException: access denied (java.util.PropertyPermission java.rmi.server.ignoreSubClasses write) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264) at java.security.AccessController.checkPermission(AccessController.java:427) at java.lang.SecurityManager.checkPermission(SecurityManager.java:536) at java.lang.System.setProperty(System.java:699) at sun.tools.jstatd.Jstatd.main(Jstatd.java:122) Cause :- The "access denied" error is expected, because "jstatd" requires a security policy file specified with the "java.security.policy" system property, if there is no security manager running on the machine. Solution :- 1) cd $ORACLE_HOME/jdk...
Read more