Do you have the property openjpa.jdbc.TransactionIsolation specified in
your persistence.xml? It *looks* like we'll only try to set the
transactionIsolation level if that property is not left to the default.
Thanks,
Rick
On Mon, Mar 24, 2014 at 10:56 AM, Vito <testfor...@163.com> wrote:
>
> Hi all,
> I'm recently doing some research with Apache ODE engine. I use Postgresql
> as its external database, openjpa as its ORM solution and bitronix as its
> transaction manager. The ODE workflow engine starts without any problem.
> But when I deploy process definition files into the engine, the exception
> came out. I paste the error content at the end of this email.
> I looked through the source code of
> org.apache.openjpa.lib.jdbc.DecoratingDataSource, and found that openjpa is
> almost definitely to meant to invoke the function of reseting transaction
> isolation level, which would be catched by Postgresql and return with an
> exception.
> Does that mean openjpa works poorly with Postgresql? Or who can tell me
> how to solve this problem.
> The error content is below:
> 17:32:05,155 ERROR [ProcessStoreImpl] Error persisting deployment record
> for {http://sample.bpel.org/bpel/sample}longFlow-1; process will not be
> available after restart!
> <openjpa-1.2.1-r752877:753278 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Cannot change
> transaction isolation level in the middle of a transaction
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:930)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getConnection(JDBCStoreManager.java:230)
> at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:371)
> at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:339)
> at
> org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:420)
> at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
> at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
> at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:206)
> at
> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
> at
> org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:57)
> at
> org.apache.openjpa.jdbc.kernel.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:235)
> at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
> at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:255)
> at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
> at
> org.apache.ode.store.jpa.ConfStoreConnectionJpa.setVersion(ConfStoreConnectionJpa.java:76)
> at
> org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:294)
> at
> org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:264)
> at
> org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:793)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: org.postgresql.util.PSQLException: Cannot change transaction
> isolation level in the middle of a transaction
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:944)
> at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
> at $Proxy5.setTransactionIsolation(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
> at $Proxy7.setTransactionIsolation(Unknown Source)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:257)
> at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:95)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:100)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:88)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(JDBCStoreManager.java:941)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:926)
> ... 27 more
> 17:32:05,163 ERROR [ProcessStoreImpl] DbError
> java.lang.RuntimeException: java.lang.IllegalStateException: no
> transaction started on this thread
> at
> org.apache.ode.store.jpa.DbConfStoreConnectionFactory.rollbackTransaction(DbConfStoreConnectionFactory.java:96)
> at
> org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:800)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.lang.IllegalStateException: no transaction started on this
> thread
> at
> bitronix.tm.BitronixTransactionManager.rollback(BitronixTransactionManager.java:150)
> at
> org.apache.ode.store.jpa.DbConfStoreConnectionFactory.rollbackTransaction(DbConfStoreConnectionFactory.java:94)
> ... 6 more
> 17:32:05,163 ERROR [DeploymentPoller] Deployment of LongFlow failed,
> aborting for now.
> org.apache.ode.bpel.iapi.ContextException: DbError
> at
> org.apache.ode.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:618)
> at
> org.apache.ode.store.ProcessStoreImpl.deploy(ProcessStoreImpl.java:264)
> at
> org.apache.ode.store.ProcessStoreImpl.deploy(ProcessStoreImpl.java:172)
> at
> org.apache.ode.axis2.deploy.DeploymentPoller.check(DeploymentPoller.java:160)
> at
> org.apache.ode.axis2.deploy.DeploymentPoller.access$300(DeploymentPoller.java:60)
> at
> org.apache.ode.axis2.deploy.DeploymentPoller$PollingThread.run(DeploymentPoller.java:251)
> Caused by: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: bitronix.tm.internal.BitronixRollbackException:
> RuntimeException thrown during beforeCompletion cycle caused transaction
> rollback
> at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
> at java.util.concurrent.FutureTask.get(FutureTask.java:83)
> at
> org.apache.ode.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:616)
> ... 5 more
> Caused by: java.lang.RuntimeException:
> bitronix.tm.internal.BitronixRollbackException: RuntimeException thrown
> during beforeCompletion cycle caused transaction rollback
> at
> org.apache.ode.store.jpa.DbConfStoreConnectionFactory.commitTransaction(DbConfStoreConnectionFactory.java:87)
> at
> org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:794)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: bitronix.tm.internal.BitronixRollbackException:
> RuntimeException thrown during beforeCompletion cycle caused transaction
> rollback
> at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:241)
> at
> bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:143)
> at
> org.apache.ode.store.jpa.DbConfStoreConnectionFactory.commitTransaction(DbConfStoreConnectionFactory.java:85)
> ... 6 more
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Cannot change
> transaction isolation level in the middle of a transaction
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:930)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.retainConnection(JDBCStoreManager.java:216)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.retainConnection(DelegatingStoreManager.java:163)
> at
> org.apache.openjpa.kernel.BrokerImpl.retainConnection(BrokerImpl.java:3710)
> at
> org.apache.openjpa.kernel.BrokerImpl.beginStoreManagerTransaction(BrokerImpl.java:1283)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1968)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1908)
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1826)
> at
> bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:532)
> at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:235)
> ... 8 more
> Caused by: org.postgresql.util.PSQLException: Cannot change transaction
> isolation level in the middle of a transaction
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:944)
> at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
> at $Proxy5.setTransactionIsolation(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
> at $Proxy7.setTransactionIsolation(Unknown Source)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:257)
> at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:95)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:100)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:88)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(JDBCStoreManager.java:941)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:926)
> ... 17 more
>
> Regards,
> Vito
>
>
>
--
*Rick Curtis*
