ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Boisvert <boisv...@intalio.com>
Subject Re: Surviving DB shutdown on Hibernate DAO
Date Mon, 16 Mar 2009 16:33:31 GMT
Agreed.  I think this is an application server (datasource management)
concern.

alex


2009/3/16 Ford, Mark <mark.ford@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" <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> <
> 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