Hello:
I am getting the following exception while using Hibernate on a small web-app running on OC4J 10.1.3.0.0 (more following exception):
org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)at business.PersistMemberListServlet.doPost(PersistMemberListServlet.java:48)at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Connection Cache with this Cache Name is Disabledat 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.oc4j.sql.DataSourceConnectionPoolDataSource.getPooledConnection(DataSourceConnectionPoolDataSource.java:87)at oracle.oc4j.sql.xa.EmulatedXADataSource.getXAConnection(EmulatedXADataSource.java:117)at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createXAConnection(ManagedConnectionFactoryImpl.java:209)at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:170)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.connector.ApplicationConnectionManager.createManagedConnection(ApplicationConnectionManager.java:1377)at oracle.j2ee.connector.ConnectionPoolImpl.createManagedConnectionFromFactory(ConnectionPoolImpl.java:327)at oracle.j2ee.connector.ConnectionPoolImpl.access$800(ConnectionPoolImpl.java:98)at oracle.j2ee.connector.ConnectionPoolImpl$NonePoolingScheme.getManagedConnection(ConnectionPoolImpl.java:1211)at oracle.j2ee.connector.ConnectionPoolImpl.getManagedConnection(ConnectionPoolImpl.java:785)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.connector.ApplicationConnectionManager.getConnectionFromPool(ApplicationConnectionManager.java:1575)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.connector.ApplicationConnectionManager.acquireConnectionContext(ApplicationConnectionManager.java:1520)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.connector.ApplicationConnectionManager.allocateConnection(ApplicationConnectionManager.java:1465)at oracle.j2ee.connector.OracleConnectionManager.unprivileged_allocateConnection(OracleConnectionManager.java:238)at oracle.j2ee.connector.OracleConnectionManager.allocateConnection(OracleConnectionManager.java:192)at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:272)at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:200)at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:142)at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:127)at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)... 20 more
--------
My hibernate.cfg.xml:
<hibernate-configuration>
<session-factory>
<property name="connection.datasource">hibernate/OracleDS</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
<property name="hibernate.current_session_context_class">
thread</property>
<property name="hibernate.cache.use_second_level_cache">true</property>
<mapping resource="business/MemberList.hbm.xml"/>
</session-factory>
</hibernate-configuration>
-------
My data-sources.xml:
<managed-data-source name="DEV10G" connection-pool-name="DEV10G Hibernate Connection" jndi-name="hibernate/OracleDS"/>
<connection-pool name="DEV10G Hibernate Connection"
disable-server-connection-pooling="false"
validate-connection="false"
abandoned-connection-timeout="1"
time-to-live-timeout="1"
connection-retry-interval="1"
inactivity-timeout="60"
initial-limit="5"
login-timeout="10"
max-connect-attempts="5"
max-connections="25"
min-connections="5"
used-connection-wait-timeout="60"
num-cached-statements="0"
property-check-interval="900">
<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource"
user="ehamacher"
password="ehamacher"
url="jdbc
racle:thin:@192.168.132.92:2224
EV10G"
>
</connection-factory>
</connection-pool>
--------
My MemberList.hbm.xml file contains <cache usage="read-write"/>
Any help would be appreciated!!
