Hello:
I get the following exception below when I call getConnection() on a javax.sql.Datasource. The checked my connection parameters many times over and they are correct. I have a feeling that it cannot find the database.
Here is the relevant portion of the data-sources.xml: <connection-pool name="XConnectionPool" abandoned-connection-timeout="10" connection-retry-interval="1" disable-server-connection-pooling="false" inactivity-timeout="60" initial-limit="5" login-timeout="0" max-connect-attempts="5" max-connections="10" min-connections="2" num-cached-statements="10" time-to-live-timeout="900" used-connection-wait-timeout="1" validate-connection="false">
<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="user" password="password" login-timeout="10" url="jdbc
racle:thin:@adomain.com:1111:SID"/>
</connection-pool>
<managed-data-source name="XDataSource" connection-pool-name="XConnectionPool" jndi-name="jdbc/GFDataSource" user="user" password="password" login-timeout="0" tx-level="global"/>
The exception: 08/08/12 14:44:37 java.sql.SQLException: Connection Cache with this Cache Name is Disabled
08/08/12 14:44:37 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
08/08/12 14:44:37 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
08/08/12 14:44:37 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
08/08/12 14:44:37 at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:310)
08/08/12 14:44:37 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:286)
08/08/12 14:44:37 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179)
08/08/12 14:44:37 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:159)
08/08/12 14:44:37 at oracle.oc4j.sql.DataSourceConnectionPoolDataSource.getPooledConnection(DataSourceConnectionPoolDataSource.java:57)
08/08/12 14:44:37 at oracle.oc4j.sql.xa.EmulatedXADataSource.getXAConnection(EmulatedXADataSource.java:92)
08/08/12 14:44:37 at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createXAConnection(ManagedConnectionFactoryImpl.java:211)
08/08/12 14:44:37 at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:170)
08/08/12 14:44:37 at com.evermind.server.connector.ApplicationConnectionManager.createManagedConnection(ApplicationConnectionManager.java:1377)
08/08/12 14:44:37 at oracle.j2ee.connector.ConnectionPoolImpl.createManagedConnectionFromFactory(ConnectionPoolImpl.java:327)
08/08/12 14:44:37 at oracle.j2ee.connector.ConnectionPoolImpl.access$800(ConnectionPoolImpl.java:98)
08/08/12 14:44:37 at oracle.j2ee.connector.ConnectionPoolImpl$NonePoolingScheme.getManagedConnection(ConnectionPoolImpl.java:1211)
08/08/12 14:44:37 at oracle.j2ee.connector.ConnectionPoolImpl.getManagedConnection(ConnectionPoolImpl.java:785)
08/08/12 14:44:37 at com.evermind.server.connector.ApplicationConnectionManager.getConnectionFromPool(ApplicationConnectionManager.java:1575)
08/08/12 14:44:37 at com.evermind.server.connector.ApplicationConnectionManager.acquireConnectionContext(ApplicationConnectionManager.java:1520)
08/08/12 14:44:37 at com.evermind.server.connector.ApplicationConnectionManager.allocateConnection(ApplicationConnectionManager.java:1465)
08/08/12 14:44:37 at oracle.j2ee.connector.OracleConnectionManager.unprivileged_allocateConnection(OracleConnectionManager.java:238)
08/08/12 14:44:37 at oracle.j2ee.connector.OracleConnectionManager.allocateConnection(OracleConnectionManager.java:192)
08/08/12 14:44:37 at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:272)
08/08/12 14:44:37 at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:200)
08/08/12 14:44:37 at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:142)
08/08/12 14:44:37 at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:127)
08/08/12 14:44:37 at util.GallupFaithConnection.getConnection(GallupFaithConnection.java:26)
08/08/12 14:44:37 at gallupfaith.ControlServlet.doGet(ControlServlet.java:22)
08/08/12 14:44:37 at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
08/08/12 14:44:37 at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
08/08/12 14:44:37 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
08/08/12 14:44:37 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
08/08/12 14:44:37 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
08/08/12 14:44:37 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
08/08/12 14:44:37 at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
08/08/12 14:44:37 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
08/08/12 14:44:37 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
08/08/12 14:44:37 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
08/08/12 14:44:37 at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
08/08/12 14:44:37 at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
08/08/12 14:44:37 at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
08/08/12 14:44:37 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
08/08/12 14:44:37 at java.lang.Thread.run(Thread.java:595)
[edit]Disable smilies. CR[/edit]
[ August 12, 2008: Message edited by: Campbell Ritchie ]