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

Popular posts from this blog

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

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

ORA-22990: LOB locators cannot span transactions