ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafal Rusin <rafal.ru...@gmail.com>
Subject Surviving DB shutdown on Hibernate DAO
Date Mon, 16 Mar 2009 14:07:54 GMT
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.WrapperNamedXAResource@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

Mime
View raw message