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 <[EMAIL PROTECTED]> 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) >
