ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sathwik <bantwalpremaku...@intalio.com>
Subject Re: Need location of ODE database script- MYSQL 5.5
Date Fri, 08 Jun 2012 06:55:16 GMT
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


Mime
View raw message