You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by SHOUKAT ALI <al...@yahoo.co.in> on 2008/08/04 16:05:01 UTC
Unknown column 'properties0_.propId' in 'field list'
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?
Re: Unknown column 'properties0_.propId' in 'field list'
Posted by Matthieu Riou <ma...@offthelip.org>.
On Tue, Aug 5, 2008 at 2:02 AM, alishoukat <al...@yahoo.co.in> wrote:
>
>
> Matthieu Riou-5 wrote:
> >
> > On Mon, Aug 4, 2008 at 7:05 AM, SHOUKAT ALI <al...@yahoo.co.in>
> > 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.
>
>
Re: Unknown column 'properties0_.propId' in 'field list'
Posted by alishoukat <al...@yahoo.co.in>.
Matthieu Riou-5 wrote:
>
> On Mon, Aug 4, 2008 at 7:05 AM, SHOUKAT ALI <al...@yahoo.co.in>
> 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.
Re: Unknown column 'properties0_.propId' in 'field list'
Posted by Matthieu Riou <ma...@offthelip.org>.
On Mon, Aug 4, 2008 at 7:05 AM, SHOUKAT ALI <al...@yahoo.co.in> 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
>
>