You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Rafal Rusin <ra...@gmail.com> on 2009/03/16 15:07:54 UTC
Surviving DB shutdown on Hibernate DAO
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
Re: Surviving DB shutdown on Hibernate DAO
Posted by Rafal Rusin <ra...@gmail.com>.
2009/3/16 Alex Boisvert <bo...@intalio.com>:
> 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 <ra...@gmail.com> 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.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 <http://www.mimuw.edu.pl/%7Errusin>
>>
>
--
Rafał Rusin
http://www.touk.pl
http://www.mimuw.edu.pl/~rrusin
Re: Surviving DB shutdown on Hibernate DAO
Posted by Alex Boisvert <bo...@intalio.com>.
Agreed. I think this is an application server (datasource management)
concern.
alex
2009/3/16 Ford, Mark <ma...@ll.mit.edu>
> 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" <bo...@intalio.com> wrote:
>
> What does "Zamknięte połączenie" mean?
>
> alex
>
> On Mon, Mar 16, 2009 at 7:07 AM, Rafal Rusin <ra...@gmail.com>
> 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.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 <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
>
Re: Surviving DB shutdown on Hibernate DAO
Posted by "Ford, Mark" <ma...@ll.mit.edu>.
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" <bo...@intalio.com> wrote:
What does "Zamknięte połączenie" mean?
alex
On Mon, Mar 16, 2009 at 7:07 AM, Rafal Rusin <ra...@gmail.com> 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.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 <http://www.mimuw.edu.pl/%7Errusin>
>
--
Mark Ford
MIT Lincoln Laboratory
244 Wood Street
Lexington MA 02420
(781) 981-1843
Re: Surviving DB shutdown on Hibernate DAO
Posted by Alex Boisvert <bo...@intalio.com>.
What does "Zamknięte połączenie" mean?
alex
On Mon, Mar 16, 2009 at 7:07 AM, Rafal Rusin <ra...@gmail.com> 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.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 <http://www.mimuw.edu.pl/%7Errusin>
>