javalinuxoracle-databasejakarta-eeoc4j

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


I am trying to make a connection with the Oracle database, using the j2ee application running on OC4J. My data-sources.xml always works in our production and UAT environment. I tried to setup on my local desktop and it is not working. The error message is --java.sql.SQLException: Connection Cache with this Cache Name is Disabled.

Oracle database version is:-

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production database.

Oracle database is on a virtual box, the host is window 10 and the guest machine is Fedora 23.

Any idea what might cause this?

thanks.


<managed-data-source name="OracleTM" connection-pool-name="Regency Connection Pool" 
       jndi-name="jdbc/GSTJOBS"/> 
<connection-pool name='Regency Connection Pool' min-connections='1' max-connections='5' 
     initial-limit='1' used-connection-wait-timeout='60' inactivity-timeout='60' 
     connection-retry-interval='1' max-connect-attempts='3' 
     validate-connection='false' num-cached-statements='1' time-to-live-timeout='-1' 
     abandoned-connection-timeout='-1' property-check-interval='900'> 

<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="Regency" 
     password="Regency" url="jdbc:oracle:thin:@localhost:1521:Regency"/> 


    
    
    

Solution

  • I got the solution,I just change the connection pool name(may have maintain in the session of oracle), as I change the connection pool name and connection have started working.