could not prepare statement

[jagan reddy]

Hi 

How to fix this issue 

 2018 4:45:03 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

ERROR: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/jbpmDS in state ACCESSIBLE with usage count 1 wrapping a JDBC LrcXAConnection on ConnectionID:1 on a JDBC LrcConnectionHandle on a JDBC LrcXAResource in state NO_TX

Apr 04, 2018 4:45:03 PM org.jbpm.shared.services.impl.TransactionalCommandService rollbackTransaction

WARNING: Could not commit session

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement

at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)

at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)

at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:316)

at org.jbpm.shared.services.impl.JpaPersistenceContext.queryStringWithParameters(JpaPersistenceContext.java:188)

at org.jbpm.shared.services.impl.JpaPersistenceContext.queryAndLockWithParametersInTransaction(JpaPersistenceContext.java:65)

at org.jbpm.executor.impl.jpa.ExecutorQueryServiceImpl$LockAndUpdateRequestInfoCommand.execute(ExecutorQueryServiceImpl.java:238)

at org.jbpm.executor.impl.jpa.ExecutorQueryServiceImpl$LockAndUpdateRequestInfoCommand.execute(ExecutorQueryServiceImpl.java:224)

at org.jbpm.shared.services.impl.TransactionalCommandService.execute(TransactionalCommandService.java:71)

at org.jbpm.executor.impl.jpa.ExecutorQueryServiceImpl.getRequestForProcessing(ExecutorQueryServiceImpl.java:211)

at org.jbpm.executor.impl.AvailableJobsExecutor.executeJob(AvailableJobsExecutor.java:36)

at org.jbpm.executor.impl.ExecutorRunnable.run(ExecutorRunnable.java:42)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:193)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:157)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1881)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1858)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)

at org.hibernate.loader.Loader.doQuery(Loader.java:906)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)

at org.hibernate.loader.Loader.doList(Loader.java:2550)

at org.hibernate.loader.Loader.doList(Loader.java:2536)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)

at org.hibernate.loader.Loader.list(Loader.java:2361)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)

at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)

at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)

at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:287)

... 15 more

Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/jbpmDS in state ACCESSIBLE with usage count 1 wrapping a JDBC LrcXAConnection on ConnectionID:1 on a JDBC LrcConnectionHandle on a JDBC LrcXAResource in state NO_TX

at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)

at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)

at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)

at com.sun.proxy.$Proxy151.prepareStatement(Unknown Source)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:159)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183)

... 31 more

Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/jbpmDS XAResource=a JDBC LrcXAResource in state NO_TX with XID a Bitronix XID [746F6D6361742D62746D2D6E6F6465300000000001490A7D00003A65 : 746F6D6361742D62746D2D6E6F6465300000000001490A7D00003A66], error=XAER_PROTO

at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)

at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)

at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)

... 39 more

Caused by: bitronix.tm.internal.BitronixXAException: resource already started on XID a Bitronix XID [746F6D6361742D62746D2D6E6F64653000000000012F532700002CE9 : 746F6D6361742D62746D2D6E6F64653000000000012F7D2E00002CEA]

at bitronix.tm.resource.jdbc.lrc.LrcXAResource.start(LrcXAResource.java:123)

at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)

at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)

at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)

... 41 more

Thanks

Jagan