ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anne Noseda <noseda.a...@gmail.com>
Subject How to improve performance
Date Tue, 13 Feb 2007 15:18:51 GMT

Hello,

I use Apache ODE in combinaison with Servicemix.
I have the following configuration : the client application calls a WS
exposed by Servicemix. The BPEL process calls many times extern WS.
I compare performance between SE BPEL and SE JSR181 doing exactly the same
business.
Actually, I have bad results for BPEL :
tests performed with SOAP UI : 5 threads - 120 seconds of execution - SMX
3.1 - ODE build on 06/02/2007 :
JSR181 : +/- 80 msg/s
BPEL : +/- 4 msg/s

So, my question, how to improve performance of a BPEL process ?

By the way, I also have sometimes errors in the console when I run the tests
such as :

ERROR - JacobVPU                       - Method "run" in class
"org.apache.ode.bpel.runtime.ASSIGN" threw an unexpected excep
tion.
java.lang.IllegalArgumentException: Object
org.opentools.minerva.connector.jdbc.JDBCManagedConnection@d591a6 is not in
pool o
rg.opentools.minerva.connector.jdbc.JDBCManagedConnectionFactory-1!
        at
org.opentools.minerva.pool.ObjectPool.releaseObject(ObjectPool.java:682)
        at
org.opentools.minerva.connector.BaseConnectionManager$SharedLocalConnectionListener.killConnection(BaseConnectionM
anager.java:464)
        at
org.opentools.minerva.connector.BaseConnectionManager$SharedLocalConnectionListener.connectionErrorOccurred(BaseCo
nnectionManager.java:427)
        at
org.opentools.minerva.connector.jdbc.BaseManagedConnection.fireConnectionEvent(BaseManagedConnection.java:87)
        at
org.opentools.minerva.connector.jdbc.JDBCManagedConnection$1.objectError(JDBCManagedConnection.java:70)
        at
org.opentools.minerva.jdbc.ConnectionInPool.firePoolEvent(ConnectionInPool.java:289)
        at
org.opentools.minerva.jdbc.ConnectionInPool.setError(ConnectionInPool.java:216)
        at
org.opentools.minerva.jdbc.StatementInPool.setError(StatementInPool.java:110)
        at
org.opentools.minerva.jdbc.ResultSetInPool.setError(ResultSetInPool.java:102)
        at
org.opentools.minerva.jdbc.ResultSetInPool.next(ResultSetInPool.java:936)
        at org.hibernate.loader.Loader.doQuery(Loader.java:685)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2145)
        at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
        at org.hibernate.loader.Loader.list(Loader.java:2024)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
        at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
        at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1129)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at
org.apache.ode.daohib.bpel.ScopeDaoImpl.getVariable(ScopeDaoImpl.java:119)
        at
org.apache.ode.bpel.engine.BpelRuntimeContextImpl.initializeVariable(BpelRuntimeContextImpl.java:429)
        at org.apache.ode.bpel.runtime.ASSIGN.evalLValue(ASSIGN.java:119)
        at org.apache.ode.bpel.runtime.ASSIGN.copy(ASSIGN.java:352)
        at org.apache.ode.bpel.runtime.ASSIGN.run(ASSIGN.java:78)
        at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
        at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
        at
org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:731)
        at
org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeMyRole(PartnerLinkMyRoleImpl.java:175)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:139)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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)
WARN  - Transaction                    - Unexpected exception from
afterCompletion; continuing
java.lang.NullPointerException
        at
org.opentools.minerva.connector.jdbc.JDBCLocalTransaction.rollback(JDBCLocalTransaction.java:57)
        at
org.opentools.minerva.connector.BaseConnectionManager$SharedLocalConnectionListener.afterCompletion(BaseConnection
Manager.java:389)
        at
org.apache.geronimo.transaction.manager.TransactionImpl.afterCompletion(TransactionImpl.java:537)
        at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:489)
        at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:276)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:256)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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)
ERROR - OdeService                     - Error invoking ODE.
java.lang.RuntimeException: java.lang.IllegalArgumentException: Object
org.opentools.minerva.connector.jdbc.JDBCManagedConnec
tion@d591a6 is not in pool
org.opentools.minerva.connector.jdbc.JDBCManagedConnectionFactory-1!
        at
org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464)
        at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
        at
org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:731)
        at
org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeMyRole(PartnerLinkMyRoleImpl.java:175)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:139)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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.lang.IllegalArgumentException: Object
org.opentools.minerva.connector.jdbc.JDBCManagedConnection@d591a6 is no
t in pool
org.opentools.minerva.connector.jdbc.JDBCManagedConnectionFactory-1!
        at
org.opentools.minerva.pool.ObjectPool.releaseObject(ObjectPool.java:682)
        at
org.opentools.minerva.connector.BaseConnectionManager$SharedLocalConnectionListener.killConnection(BaseConnectionM
anager.java:464)
        at
org.opentools.minerva.connector.BaseConnectionManager$SharedLocalConnectionListener.connectionErrorOccurred(BaseCo
nnectionManager.java:427)
        at
org.opentools.minerva.connector.jdbc.BaseManagedConnection.fireConnectionEvent(BaseManagedConnection.java:87)
        at
org.opentools.minerva.connector.jdbc.JDBCManagedConnection$1.objectError(JDBCManagedConnection.java:70)
        at
org.opentools.minerva.jdbc.ConnectionInPool.firePoolEvent(ConnectionInPool.java:289)
        at
org.opentools.minerva.jdbc.ConnectionInPool.setError(ConnectionInPool.java:216)
        at
org.opentools.minerva.jdbc.StatementInPool.setError(StatementInPool.java:110)
        at
org.opentools.minerva.jdbc.ResultSetInPool.setError(ResultSetInPool.java:102)
        at
org.opentools.minerva.jdbc.ResultSetInPool.next(ResultSetInPool.java:936)
        at org.hibernate.loader.Loader.doQuery(Loader.java:685)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2145)
        at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
        at org.hibernate.loader.Loader.list(Loader.java:2024)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
        at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
        at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1129)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at
org.apache.ode.daohib.bpel.ScopeDaoImpl.getVariable(ScopeDaoImpl.java:119)
        at
org.apache.ode.bpel.engine.BpelRuntimeContextImpl.initializeVariable(BpelRuntimeContextImpl.java:429)
        at org.apache.ode.bpel.runtime.ASSIGN.evalLValue(ASSIGN.java:119)
        at org.apache.ode.bpel.runtime.ASSIGN.copy(ASSIGN.java:352)
        at org.apache.ode.bpel.runtime.ASSIGN.run(ASSIGN.java:78)
        at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
        ... 15 more
ERROR - JobStoreJTA                    - MisfireHandler: Error handling
misfires: A lock could not be obtained within the tim
e requested
org.quartz.JobPersistenceException: A lock could not be obtained within the
time requested [See nested exception: java.sql.SQ
LException: A lock could not be obtained within the time requested]
        at
org.apache.ode.bpel.scheduler.quartz.JobStoreJTA.doRecoverMisfires(JobStoreJTA.java:1212)
        at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:2409)
        at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:2428)
* Nested Exception (Underlying Cause) ---------------
ERROR 40XL1: A lock could not be obtained within the time requested
        at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at org.apache.derby.impl.services.locks.LockSet.lockObject(Unknown
Source)
        at
org.apache.derby.impl.services.locks.SinglePool.zeroDurationlockObject(Unknown
Source)
        at
org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown
Source)
        at
org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead(Unknown
Source)
        at
org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
        at
org.opentools.minerva.jdbc.ResultSetInPool.next(ResultSetInPool.java:934)
        at
org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggersInState(StdJDBCDelegate.java:250)
        at
org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:730)
        at
org.apache.ode.bpel.scheduler.quartz.JobStoreJTA.doRecoverMisfires(JobStoreJTA.java:1210)
        at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:2409)
        at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:2428)

or :

WARN  - JDBCExceptionReporter          - SQL Error: 20000, SQLState: 23505
ERROR - JDBCExceptionReporter          - The statement was aborted because
it would have caused a duplicate key value in a un
ique or primary key constraint or unique index identified by
'SQL070209034436510' defined on 'BPEL_PROCESS'.
ERROR - AbstractFlushingEventListener  - Could not synchronize database
state with session
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
WARN  - JDBCExceptionReporter          - SQL Error: 20000, SQLState: 23505
ERROR - BpelDAOConnectionImpl          - DbError
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - JDBCExceptionReporter          - The statement was aborted because
it would have caused a duplicate key value in a un
ique or primary key constraint or unique index identified by
'SQL070209034436510' defined on 'BPEL_PROCESS'.
WARN  - JDBCExceptionReporter          - SQL Error: 20000, SQLState: 23505
ERROR - OdeService                     - Error invoking ODE.
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - AbstractFlushingEventListener  - Could not synchronize database
state with session
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - JDBCExceptionReporter          - The statement was aborted because
it would have caused a duplicate key value in a un
ique or primary key constraint or unique index identified by
'SQL070209034436510' defined on 'BPEL_PROCESS'.
WARN  - JDBCExceptionReporter          - SQL Error: 20000, SQLState: 23505
ERROR - BpelDAOConnectionImpl          - DbError
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - AbstractFlushingEventListener  - Could not synchronize database
state with session
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - JDBCExceptionReporter          - The statement was aborted because
it would have caused a duplicate key value in a un
ique or primary key constraint or unique index identified by
'SQL070209034436510' defined on 'BPEL_PROCESS'.
ERROR - OdeService                     - Error invoking ODE.
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - BpelDAOConnectionImpl          - DbError
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - AbstractFlushingEventListener  - Could not synchronize database
state with session
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - OdeService                     - Error invoking ODE.
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - BpelDAOConnectionImpl          - DbError
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more
ERROR - OdeService                     - Error invoking ODE.
org.hibernate.exception.ConstraintViolationException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HProcess]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:978)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1545)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getProcess(BpelDAOConnectionImpl.java:97)
        at
org.apache.ode.bpel.engine.BpelProcess.getProcessDAO(BpelProcess.java:352)
        at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:131)
        at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:114)
        at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:229)
        at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:141)
        at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(JbiMessageExchangeEventRouter.java:47)
        at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        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: The statement was aborted because it would
have caused a duplicate key value in a unique or
 primary key constraint or unique index identified by 'SQL070209034436510'
defined on 'BPEL_PROCESS'.
        at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:99)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)
        ... 25 more

When I have no error message, I have also sometimes warning message like
that :

WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
11; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
13; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
62; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
78; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
536; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
576; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
577; ignoring.
WARN  - OdeConsumer                    - Cannot locate ODE message exchange:
702; ignoring.

These errors and warning appear more frequently when I test with 5 threads
simultaneous.
When I test with 1 thread, I have no error and no warning.

Thanks for the help,

Anne.
-- 
View this message in context: http://www.nabble.com/How-to-improve-performance-tf3221221.html#a8946129
Sent from the Apache Ode User mailing list archive at Nabble.com.


Mime
View raw message