On Tue, Aug 5, 2008 at 2:02 AM, alishoukat <[EMAIL PROTECTED]> wrote:
> > > 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? Just as well as in Hibernate, they're also persisted and configurable. Matthieu > > -- > 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. > >
