ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Veresh Jain <ver...@intalio.com>
Subject Re: Error loading immediate jobs from database. java.sql.SQLException: Closed Connection
Date Wed, 23 Mar 2011 23:38:05 GMT


This means your scheduler is working on a connection object which is 
closed , you need to provide complete stack trace.


On 03/23/2011 08:53 AM, Vikram Deshmukh wrote:
> I am using ODE 1.3.4 with JBoss 4.2.2. And I am using the BPEL in in-memory
> mode set to true.
> The functioning of ODE and BPEL goes fine for some time and suddenly it
> starts throwing the Exception Trace shown below.
>
> Please find the ode-axis2.properties and oracle-ds.xml file uploaded with
> this post.
> Please let me know what needs to be done to get rid of this exception trace.
> - Any JBoss Datasource configuration missing?
> - Any ODE configuration missing?
>
> 15:43:16,055 INFO  [STDOUT] ERROR - SimpleScheduler.doLoadImmediate(730) |
> Error loading immediate jobs from database.
> org.apache.ode.scheduler.simple.DatabaseException: java.sql.SQLException:
> Closed Connection
>          at
> org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:349)
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:699)
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:698)
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284)
>
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239)
>
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:697)
>
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:842)
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:658)
>          at
> org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:656)
>          at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>          at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>          at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>          at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>          at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Closed Connection
>          at
> oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
>          at
> oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
>          at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
>          at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
>          at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
>          at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3046)
>          at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349)
>          at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344)
>          at
> org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
>          at
> org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:281)
>          ... 13 more

Mime
View raw message