Exception on trying to run the new ODE with MYSQL DB

[Rosalin Pattnaik <ro...@gmail.com>]

Hi,

I tried running the new ode with MYSQL Database.
My ode-axis2.properties had the following entry:

ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ODEDB
ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl
ode-axis2.db.emb.name=java:comp/env/jdbc/ODEDB

In ode.mysql.properties the following :

hibernate.hbm2ddl.auto = update
hibernate.current_session_context_class=jta
hibernate.transaction.manager_lookup_class=org.apache.ode.daohib.HibernateTransactionManagerLookup
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

While starting the ODE server i get the following error:


I get the following error message:

ERROR - GeronimoLog.error(104) | Unknown column 'this_.ACTIVE_' in 'field
list'

17:32:08,556 ERROR [JDBCExceptionReporter] Unknown column 'this_.ACTIVE_' in
'field list'

ERROR - GeronimoLog.error(108) | DbError

org.hibernate.exception.SQLGrammarException: could not execute query

        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:67)

        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:43)

        at org.hibernate.loader.Loader.doList(Loader.java:2223)

        at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)

        at org.hibernate.loader.Loader.list(Loader.java:2099)

        at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java

:94)

        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)

        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)

        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOCo

nnectionImpl.java:97)

        at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.j

ava:621)

        at
org.apache.ode.bpel.engine.BpelProcess.access$1500(BpelProcess.java:7

5)

        at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$3.call(BpelProc

ess.java:748)

        at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(Simpl

eScheduler.java:173)

        at
org.apache.ode.scheduler.simple.SimpleScheduler$1.call(SimpleSchedule

r.java:159)

        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)

        at java.util.concurrent.FutureTask.run(FutureTask.java:123)

        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec

utor.java:650)

        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

.java:675)

        at java.lang.Thread.run(Thread.java:595)

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown
column '

this_.ACTIVE_' in 'field list'

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1313)

        at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1448)

        at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(

DelegatingPreparedStatement.java:92)

        at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:

186)

        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)

        at org.hibernate.loader.Loader.doQuery(Loader.java:674)

        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo

ader.java:236)

        at org.hibernate.loader.Loader.doList(Loader.java:2220)

        ... 17 more

17:32:08,556 ERROR [BpelDAOConnectionImpl] DbError

org.hibernate.exception.SQLGrammarException: could not execute query

        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:67)

        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:43)

        at org.hibernate.loader.Loader.doList(Loader.java:2223)

        at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)

        at org.hibernate.loader.Loader.list(Loader.java:2099)

        at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java

:94)

        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)

        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)

        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOCo

nnectionImpl.java:97)

        at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.j

ava:621)

        at
org.apache.ode.bpel.engine.BpelProcess.access$1500(BpelProcess.java:7

5)

        at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$3.call(BpelProc

ess.java:748)

        at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(Simpl

eScheduler.java:173)

        at
org.apache.ode.scheduler.simple.SimpleScheduler$1.call(SimpleSchedule

r.java:159)

        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)

        at java.util.concurrent.FutureTask.run(FutureTask.java:123)

        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec

utor.java:650)

        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

.java:675)

        at java.lang.Thread.run(Thread.java:595)