You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ode.apache.org by Simon Tjoa <st...@casixx.com> on 2008/04/19 10:36:49 UTC

Simple Scheduler

Dear Apache Ode Community, 

I tried to configure Apache Ode on JBoss with DB2. Unfortunately as soon as 
I try to switch the database from Derby to DB2, I get the following Error. 

I hope you can give me an advise how to solve this issue. 

Thanks a lot,
  Simon 

2008-04-19 10:16:00,165 INFO  [STDOUT] 10:16:00,165 ERROR [SimpleScheduler] 
Database error upgrading jobs.
org.apache.ode.scheduler.simple.DatabaseException: com.ibm.db2.jcc.b.nm: DB2 
SQL Error: SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.50.152
	at 
org.apache.ode.scheduler.simple.JdbcDelegate.updateAssignToNode(JdbcDelegate 
.java:246)
	at 
org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java: 
451)
	at 
org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java: 
447)
	at 
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleSchedu 
ler.java:179)
	at 
org.apache.ode.scheduler.simple.SimpleScheduler.doUpgrade(SimpleScheduler.ja 
va:445)
	at 
org.apache.ode.scheduler.simple.SimpleScheduler$UpgradeJobsTask.run(SimpleSc 
heduler.java:552)
	at 
org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java 
:391)
	at 
org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:137 
)
	at java.lang.Thread.run(Thread.java:595)

Re: Simple Scheduler

Posted by Alex Boisvert <bo...@intalio.com>.

The SimpleScheduler uses hand-coded JDBC calls for efficiency and apparently
the default SQL statement doesn't work on DB2.

The default statement is,
update ODE_JOB set nodeid = ? where nodeid is null and scheduled = 0 and
mod(ts,?) = ? and ts < ?

Can you file a bug and if you have the motivation try to come up with the
equivalent SQL statement that would work on DB2?

thanks,
alex

On Sat, Apr 19, 2008 at 1:36 AM, Simon Tjoa <st...@casixx.com> wrote:

> Dear Apache Ode Community,
> I tried to configure Apache Ode on JBoss with DB2. Unfortunately as soon
> as I try to switch the database from Derby to DB2, I get the following
> Error.
> I hope you can give me an advise how to solve this issue.
> Thanks a lot,
>  Simon
> 2008-04-19 10:16:00,165 INFO  [STDOUT] 10:16:00,165 ERROR
> [SimpleScheduler] Database error upgrading jobs.
> org.apache.ode.scheduler.simple.DatabaseException: com.ibm.db2.jcc.b.nm:
> DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.50.152
>        at
> org.apache.ode.scheduler.simple.JdbcDelegate.updateAssignToNode(JdbcDelegate
> .java:246)
>        at
> org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java:
> 451)
>        at
> org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java:
> 447)
>        at
> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleSchedu
> ler.java:179)
>        at
> org.apache.ode.scheduler.simple.SimpleScheduler.doUpgrade(SimpleScheduler.ja
> va:445)
>        at
> org.apache.ode.scheduler.simple.SimpleScheduler$UpgradeJobsTask.run(SimpleSc
> heduler.java:552)
>        at
> org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java
> :391)
>        at
> org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:137
> )
>        at java.lang.Thread.run(Thread.java:595)
>