ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ford, Mark" <mark.f...@ll.mit.edu>
Subject Re: Surviving DB shutdown on Hibernate DAO
Date Mon, 16 Mar 2009 16:08:36 GMT
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" <boisvert@intalio.com> wrote:

What does "Zamknięte połączenie" mean?

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




--
Mark Ford
MIT Lincoln Laboratory
244 Wood Street
Lexington MA 02420
(781) 981-1843

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message