2009/3/16 Alex Boisvert <[email protected]>: > What does "Zamknięte połączenie" mean?
It means "Connection is closed". By the way this looks like a problem with a connection pool in servicemix, because it returns closed connection in _db.getConnection() in SimpleScheduler's JdbcDelegate. So it's actually not hibernate dao related and not really ODE related. However I'm curious whether you passed database restart test for some other configuration. > > 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> >> > -- Rafał Rusin http://www.touk.pl http://www.mimuw.edu.pl/~rrusin
