Matthieu Riou-5 wrote: > > 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 > > >> >> > >
we tried to user hibernate so that we can persist info about events. how does events are supported in OpenJPA? -- View this message in context: http://www.nabble.com/Unknown-column-%27properties0_.propId%27-in-%27field-list%27-tp18812393p18827201.html Sent from the Apache Ode User mailing list archive at Nabble.com.
