ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafal Rusin <rafal.ru...@gmail.com>
Subject Re: Surviving DB shutdown on Hibernate DAO
Date Mon, 16 Mar 2009 16:12:28 GMT
2009/3/16 Alex Boisvert <boisvert@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 <rafal.rusin@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

Mime
View raw message