Closed Connection - courtesy of google translate. Looks like the connections in the pool are in an invalid state. I don't recall the exact syntax, but there are various statements you can add to your datasource so it will validate that the connections are good before returning them. At least this was the case when configuring datasources for JBOSS.
On 3/16/09 11:59 AM, "Alex Boisvert" <[email protected]> wrote: What does "Zamknięte połączenie" mean? alex On Mon, Mar 16, 2009 at 7:07 AM, Rafal Rusin <[email protected]> wrote: > I run ODE with Oracle and restarted Oracle server. I got a following > exception endlessly each second: > > 14:51:26,725 | WARN | OdeScheduler | Transaction | > action.manager.TransactionImpl 212 | Unable to enlist XAResource > org.apache.geronimo.transaction.manager.wrappernamedxaresou...@1eda7a3, > erro > oracle.jdbc.xa.OracleXAException > at > oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1120) > at > oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:249) > at > org.apache.geronimo.transaction.manager.WrapperNamedXAResource.start(WrapperNamedXAResource.java:86) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) > at > org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:54) > at > org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:88) > at > org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43) > at > org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39) > at > org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66) > at > org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87) > at > org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56) > at > org.apache.ode.scheduler.simple.JdbcDelegate.getConnection(JdbcDelegate.java:247) > at > org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:167) > at > org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:473) > at > org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:472) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:208) > at > org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:471) > at > org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:587) > at > org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java:448) > at > org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:152) > at java.lang.Thread.run(Thread.java:595) > 14:51:26,726 | ERROR | OdeScheduler | SimpleScheduler | > heduler.simple.SimpleScheduler 485 | Error loading immediate jobs > from database. > org.apache.ode.scheduler.simple.DatabaseException: > java.sql.SQLException: Zamknięte połączenie > at > org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:188) > at > org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:473) > at > org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:472) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:208) > at > org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:471) > at > org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:587) > at > org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java:448) > at > org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:152) > at java.lang.Thread.run(Thread.java:595) > Caused by: java.sql.SQLException: Zamknięte połączenie > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) > at > oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:873) > at > oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:792) > at > oracle.jdbc.OracleConnectionWrapper.prepareStatement(OracleConnectionWrapper.java:92) > at > org.tranql.connector.jdbc.ConnectionHandle.prepareStatement(ConnectionHandle.java:231) > at > org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:168) > ... 8 more > > Did you run successfully similar tests with Hibernate DAO and some > other configuration? > > Regards, > -- > Rafał Rusin > http://www.touk.pl > http://www.mimuw.edu.pl/~rrusin <http://www.mimuw.edu.pl/%7Errusin> > -- Mark Ford MIT Lincoln Laboratory 244 Wood Street Lexington MA 02420 (781) 981-1843
