Hello:

I am getting the following exception while using Hibernate 3.2.6 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 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.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"/>

--------

Messages at startup:

Feb 20, 2008 8:57:33 AM com.oracle.corba.ee.impl.orb.ORBServerExtensionProviderImpl preInitApplicationServer
WARNING: ORB ignoring configuration changes. Restart OC4J to apply new ORB configuration.
Feb 20, 2008 8:57:34 AM oracle.j2ee.util.LoggingUtils logAndReturnMessage
WARNING: Exception occurred setting cache manager property InitialLimit. Exception: java.lang.reflect.InvocationTargetException.
Feb 20, 2008 8:57:34 AM oracle.j2ee.util.LoggingUtils logAndReturnMessage
WARNING: Exception occurred setting cache manager property InitialLimit. Exception: java.lang.reflect.InvocationTargetException.
Ready message received from Oc4jNotifier.
Embedded OC4J startup time: 15473 ms.

------------

Any help would be appreciated!