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