1 Reply Latest reply on Nov 15, 2013 11:35 AM by Wolf-Dieter Fink

    Hornetq persistence error on jboss eap 6

    Unice Gwe Mbuamuh Newbie

      Hi,

       

      Upon processing the message in the queue by the message driven bean, i get the following error message. has anyone seen thhis before or can anyone throw some light into why i am having this error and how i can fix it? Please find the message driven bean and standalone-full.xml file attached. Thank you for your help.

       

       

      10:02:34,794 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-1 (HornetQ-client-global-threads-1074963131)) ORA-01461: can bind a LONG value only for insert into a LONG column

       

      10:02:34,797 WARN  [com.arjuna.ats.arjuna] (Thread-1 (HornetQ-client-global-threads-1074963131)) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffff0a34451f:535e584c:5285f11e:14, org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization@32b3f716 >: javax.persistence.QueryTimeoutException: could not execute statement

          at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1349) [hibernate-entitymanager-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [hibernate-entitymanager-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.ejb.AbstractEntityManagerImpl$CallbackExceptionMapperImpl.mapManagedFlushFailure(AbstractEntityManagerImpl.java:1510) [hibernate-entitymanager-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorImpl.beforeCompletion(SynchronizationCallbackCoordinatorImpl.java:117) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:53) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:273)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:93)

          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1165)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)

          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

          at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.afterDelivery(MessageEndpointInvocationHandler.java:72) [jboss-as-ejb3-7.2.0.Final-redhat-4.jar:7.2.0.Final-redhat-4]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_45]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_45]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_45]

          at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_45]

          at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.handle(AbstractInvocationHandler.java:60) [jboss-as-ejb3-7.2.0.Final-redhat-4.jar:7.2.0.Final-redhat-4]

          at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:136) [jboss-as-ejb3-7.2.0.Final-redhat-4.jar:7.2.0.Final-redhat-4]

          at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73) [jboss-as-ejb3-7.2.0.Final-redhat-4.jar:7.2.0.Final-redhat-4]

          at com.sun.proxy.$Proxy71.afterDelivery(Unknown Source)

          at org.hornetq.ra.inflow.HornetQMessageHandler.onMessage(HornetQMessageHandler.java:322)

          at org.hornetq.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:1084)

          at org.hornetq.core.client.impl.ClientConsumerImpl.access$400(ClientConsumerImpl.java:56)

          at org.hornetq.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1229)

          at org.hornetq.utils.OrderedExecutorFactory$OrderedExecutor$1.run(OrderedExecutorFactory.java:106)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_45]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_45]

          at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]

      Caused by: org.hibernate.QueryTimeoutException: could not execute statement

          at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:151) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3058) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3499) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:328) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1233) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          at org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorImpl.beforeCompletion(SynchronizationCallbackCoordinatorImpl.java:112) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          ... 25 more

      Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

       

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:926) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:200) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:238) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1446) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1757) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4372) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4539) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:5577) [ojdbc6_g-11.2.0.3.jar:11.2.0.3.0]

          at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)

          at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]

          ... 37 more

        • 1. Re: Hornetq persistence error on jboss eap 6
          Wolf-Dieter Fink Master

          I suppose that is not really a HornetQ problem.

          You might enable SQL spy logging, add the spy=true and the logger to your configuration and you will see the SQL statements which might give you a hint what the problem is.

           

          <datasource jndi-name="java:jboss/datasources/..." pool-name="..." enabled="true" spy="true">

          <logger category="jboss.jdbc.spy">
            <level name="TRACE"/>
          </logger>