Agreed. I think this is an application server (datasource management) concern.
alex 2009/3/16 Ford, Mark <[email protected]> > 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> < > http://www.mimuw.edu.pl/%7Errusin> > > > > > > > -- > Mark Ford > MIT Lincoln Laboratory > 244 Wood Street > Lexington MA 02420 > (781) 981-1843 >
