Ignore my earlier mail.
My mistake, while changing the type=InnoDB to Engine=InnoDB, I had also
changed the type column in ODE_JOB table.
On 06/08/2012 11:58 AM, Sathwik wrote:
Hi,
I have build the code from the trunk. I want to know where are the
database scripts generated.
I want the scripts for mysql 5.5.
I actually took this script after the build from this location
(./dao-jpa-ojpa-derby/target/mysql.sql). But when I start the tomcat
server I get this exception
2012-06-08 11:52:18,087 81078 ERROR
[org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-1:) Error
loading immediate jobs from database.
org.apache.ode.scheduler.simple.DatabaseException:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'type' in 'field list'
at
org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:350)
at
org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java:724)
at
org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java:722)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:286)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:241)
at
org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:722)
at
org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:871)
at
org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:683)
at
org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:680)
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:662)
regards,
sathwik
