On Mon, Aug 4, 2008 at 7:05 AM, SHOUKAT ALI <[EMAIL PROTECTED]> wrote:
> using mySQL with ode. > using ode 1.2, mysql database is created using mysql.sql provided with > download. > when i am trying to deploy a BPEL process i am getting DBError as follows: > > > ------------------------------------------------------------------------------------------------------ > > 19:12:25,477 ERROR [[AxisServlet]] Allocate exception for servlet > AxisServlet > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column > 'properties0_.propId' 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.java: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(Loader.java:236) > at org.hibernate.loader.Loader.loadCollection(Loader.java:1994) > at > org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36) > at > org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:56 > 5) > at > org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeColl > ectionEventListener.java:60) > at > org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716) > at > org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:4 > 54) > at > org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java: > 797) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:241) > at org.hibernate.loader.Loader.doList(Loader.java:2220) > 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.apache.ode.store.hib.ConfStoreConnectionHib.getDeploymentUnits(ConfStoreConnectionHib.java:102) > at > org.apache.ode.store.ProcessStoreImpl$6.call(ProcessStoreImpl.java:458) > at > org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:701) > 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(ThreadPoolExecutor.java:650) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) > at java.lang.Thread.run(Thread.java:595) > > > ------------------------------------------------------------------------------------------------------ > > am using a properties file ode-axis2.properties > containing following lines: > > > ------------------------------------------------------------------------------------------------------ > > 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=hibdb > > > ------------------------------------------------------------------------------------------------------ > > where odedb is the database in mySQL. > > > can anyone help? > Looks like you're using the Hibernate persistence layer which is mostly deprecated. The scripts in the sql directory of our distribution are for OpenJPA. Matthieu > >
