Hi Alexis,
I did a rake build to generate schemas using dao-hibernate-db module.
However it doesn't generate schema for mysql. It generated for oracle,
derby, hsql, firebird, postgres and sqlserver. I took derby.sql and modified
the schema to make it work on mysql database. However I am getting the
following exception while trying to deploy a process (Full Stack trace
attached):
ERROR - GeronimoLog.error(104) | Field 'ID' doesn't have a default value
15:10:16,453 ERROR [JDBCExceptionReporter] Field 'ID' doesn't have a default
value
ERROR - GeronimoLog.error(108) | DbError
org.hibernate.exception.GenericJDBCException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
Thanks,
Nagendra
On Tue, Jan 6, 2009 at 11:44 AM, Nagendra Inuguri <[email protected]>wrote:
> Hi Alexis,
>
> Thanks for your reply. Good to know that JPA and hibernate uses different
> database schemas. Where can I find the sql statements to create
> hibernate compliant tables in mysql?
>
> Can you also please let me know why
> org.apache.ode.dao.jpa.BPELDAOConnectionImpl class doesn't implement
> bpelEventQuery and
> bpelEventTimelineQuery methods? These methods are called while using
> management API and hence I am getting an UnsupportedOperationException.
>
> Thanks,
> Nagendra
>
> On Tue, Jan 6, 2009 at 1:28 AM, Alexis Midon <[email protected]> wrote:
>
>> Hi Nagendra,
>>
>> you're getting that error because you cannot use Hibernate with a JPA
>> database schema. Schemas are not the same for Hibernate and JPA.
>>
>> So to fix your issue, you have to point ODE to a database containing the
>> Hibernate data model.
>> The schemas files are generated by the module "dao-hibernate-db".
>>
>> Alexis
>>
>>
>> On Sun, Jan 4, 2009 at 10:54 PM, Nagendra Inuguri <[email protected]
>> >wrote:
>>
>> > Hi,
>> >
>> > I am using ODE with mysql database. My ode-axis2.properties file has the
>> > following settings:
>> >
>> > ode-axis2.db.mode=EXTERNAL
>> >
>> > ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ODEDB
>> >
>> >
>> > Everything works fine with these settings. However when I try to use
>> > management API to receive events, I get the following error. (Full stack
>> > trace attached in ode-mysql-jpa.txt):
>> >
>> > ERROR - GeronimoLog.error(108) | Exception during database operation
>> >
>> > java.lang.UnsupportedOperationException
>> >
>> > at
>> >
>> org.apache.ode.dao.jpa.BPELDAOConnectionImpl.bpelEventQuery(BPELDAOConnectionImpl.java:54)
>> >
>> >
>> > When I see the ODE source I came to know that this is happening because
>> > org.apache.ode.dao.jpa.BPELDAOConnectionImpl has a couple of methods
>> that
>> > throws UnsupportedOperationException. Why are these methods
>> (bpelEventQuery,
>> > bpelEventTimelineQuery) simply throwing this exception? By default ode
>> uses
>> > this jpa dao implementation. Am I supposed to use a different dao
>> > implementation?
>> >
>> >
>> > So I tried adding the following line in ode-axis2.properties to use
>> > hibernate dao implementation:
>> >
>> >
>> >
>> ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl
>> >
>> > After adding this line management API works fine. However while
>> deploying a
>> > process I am getting the following error (Full stack trace attached in
>> > ode-mysql-hibernate.txt):
>> >
>> > ERROR - GeronimoLog.error(104) | Unknown column 'properties0_.propId' in
>> > 'field list'
>> >
>> > 12:02:00,484 ERROR [JDBCExceptionReporter] Unknown column
>> > 'properties0_.propId' in 'field list'
>> >
>> > ERROR - GeronimoLog.error(108) | DbError
>> >
>> > org.hibernate.exception.SQLGrammarException: could not initialize a
>> > collection: [org.apache.ode.store.hib.ProcessConfDaoImpl.
>> >
>> > properties_#{http://soa-matrix.com/example}Flow-1<http://soa-matrix.com/example%7DFlow-1>
>> <http://soa-matrix.com/example%7DFlow-1>
>> > ]
>> >
>> >
>> >
>> > To summarize, if I use mysql with default dao implementation (which is
>> in
>> > jpa package), I am not able to use management API. If I use mysql with
>> > hibernate dao implementation, I am getting an error while deploying a
>> > process. Is there any work around for this problem?
>> >
>> >
>> > Thanks,
>> >
>> > Nagendra
>> >
>>
>
>
ERROR - GeronimoLog.error(104) | Field 'ID' doesn't have a default value
15:10:16,453 ERROR [JDBCExceptionReporter] Field 'ID' doesn't have a default
value
ERROR - GeronimoLog.error(108) | DbError
org.hibernate.exception.GenericJDBCException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventLi
stener.java:187)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:1
72)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.createProcess(BpelDAOConnectionImpl.java:87)
at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.java:641)
at
org.apache.ode.bpel.engine.BpelProcess.access$1500(BpelProcess.java:75)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$3.call(BpelProcess.java:748)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:173)
at
org.apache.ode.scheduler.simple.SimpleScheduler$1.call(SimpleScheduler.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(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Field 'ID' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
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.executeUpdate(PreparedStatement.java:1585)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 26 more
15:10:16,453 ERROR [BpelProcess] DbError
org.hibernate.exception.GenericJDBCException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventLi
stener.java:187)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:1
72)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.createProcess(BpelDAOConnectionImpl.java:87)
at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.java:641)
at
org.apache.ode.bpel.engine.BpelProcess.access$1500(BpelProcess.java:75)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$3.call(BpelProcess.java:748)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:173)
at
org.apache.ode.scheduler.simple.SimpleScheduler$1.call(SimpleScheduler.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(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Field 'ID' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
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.executeUpdate(PreparedStatement.java:1585)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 26 more
ERROR - GeronimoLog.error(108) | DbError
java.util.concurrent.ExecutionException:
org.apache.ode.bpel.iapi.BpelEngineException: DbError
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205)
at java.util.concurrent.FutureTask.get(FutureTask.java:80)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch.doHydrate(BpelProcess.java:746)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch.access$100(BpelProcess.java:654)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$2.run(BpelProcess.java:666)
at org.apache.ode.bpel.engine.NStateLatch.latch(NStateLatch.java:89)
at org.apache.ode.bpel.engine.BpelProcess.hydrate(BpelProcess.java:547)
at
org.apache.ode.bpel.engine.BpelServerImpl.register(BpelServerImpl.java:277)
at org.apache.ode.axis2.ODEServer.handleEvent(ODEServer.java:544)
at org.apache.ode.axis2.ODEServer.access$100(ODEServer.java:73)
at
org.apache.ode.axis2.ODEServer$ProcessStoreListenerImpl.onProcessStoreEvent(ODEServer.java:530)
at
org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:501)
at
org.apache.ode.store.ProcessStoreImpl.fireStateChange(ProcessStoreImpl.java:507)
at
org.apache.ode.store.ProcessStoreImpl.deploy(ProcessStoreImpl.java:284)
at
org.apache.ode.axis2.deploy.DeploymentPoller.check(DeploymentPoller.java:144)
at
org.apache.ode.axis2.deploy.DeploymentPoller.access$300(DeploymentPoller.java:55)
at
org.apache.ode.axis2.deploy.DeploymentPoller$PollingThread.run(DeploymentPoller.java:188)
Caused by: org.apache.ode.bpel.iapi.BpelEngineException: DbError
at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.java:650)
at
org.apache.ode.bpel.engine.BpelProcess.access$1500(BpelProcess.java:75)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$3.call(BpelProcess.java:748)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:173)
at
org.apache.ode.scheduler.simple.SimpleScheduler$1.call(SimpleScheduler.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(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventLi
stener.java:187)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:1
72)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.createProcess(BpelDAOConnectionImpl.java:87)
at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.java:641)
... 9 more
Caused by: java.sql.SQLException: Field 'ID' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
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.executeUpdate(PreparedStatement.java:1585)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 26 more
15:10:16,593 ERROR [NStateLatch] DbError
java.util.concurrent.ExecutionException:
org.apache.ode.bpel.iapi.BpelEngineException: DbError
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205)
at java.util.concurrent.FutureTask.get(FutureTask.java:80)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch.doHydrate(BpelProcess.java:746)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch.access$100(BpelProcess.java:654)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$2.run(BpelProcess.java:666)
at org.apache.ode.bpel.engine.NStateLatch.latch(NStateLatch.java:89)
at org.apache.ode.bpel.engine.BpelProcess.hydrate(BpelProcess.java:547)
at
org.apache.ode.bpel.engine.BpelServerImpl.register(BpelServerImpl.java:277)
at org.apache.ode.axis2.ODEServer.handleEvent(ODEServer.java:544)
at org.apache.ode.axis2.ODEServer.access$100(ODEServer.java:73)
at
org.apache.ode.axis2.ODEServer$ProcessStoreListenerImpl.onProcessStoreEvent(ODEServer.java:530)
at
org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:501)
at
org.apache.ode.store.ProcessStoreImpl.fireStateChange(ProcessStoreImpl.java:507)
at
org.apache.ode.store.ProcessStoreImpl.deploy(ProcessStoreImpl.java:284)
at
org.apache.ode.axis2.deploy.DeploymentPoller.check(DeploymentPoller.java:144)
at
org.apache.ode.axis2.deploy.DeploymentPoller.access$300(DeploymentPoller.java:55)
at
org.apache.ode.axis2.deploy.DeploymentPoller$PollingThread.run(DeploymentPoller.java:188)
Caused by: org.apache.ode.bpel.iapi.BpelEngineException: DbError
at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.java:650)
at
org.apache.ode.bpel.engine.BpelProcess.access$1500(BpelProcess.java:75)
at
org.apache.ode.bpel.engine.BpelProcess$HydrationLatch$3.call(BpelProcess.java:748)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:173)
at
org.apache.ode.scheduler.simple.SimpleScheduler$1.call(SimpleScheduler.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(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventLi
stener.java:187)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:1
72)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.createProcess(BpelDAOConnectionImpl.java:87)
at
org.apache.ode.bpel.engine.BpelProcess.bounceProcessDAO(BpelProcess.java:641)
... 9 more
Caused by: java.sql.SQLException: Field 'ID' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
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.executeUpdate(PreparedStatement.java:1585)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 26 more
ERROR - GeronimoLog.error(104) | Latch error, was releasing for state 1 but
actually in -1
15:10:16,812 ERROR [NStateLatch] Latch error, was releasing for state 1 but
actually in -1
