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
