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>
>