0 Replies Latest reply on Feb 13, 2013 8:36 AM by y lab

    Jboss AS 7 transactions' Problem

    y lab Newbie

      Hi ,

      I have a J2EE apllication that use jbpm5 running into jboss 7.1.1. This application use jbpm5 with persistence (datasource 1) and inside the process

      deployed as .war in ear. in this ear i have onather .war (business logic , that interact with datasource2)

       

      Inside the jbpm5 i call a service in in the second .war that use datasource2 (Seconde database)

       

      i use jbpm5 with persistence and jta tranasaction. all work fine.

      But when i want to access from my process to the seconde database in orrder to use some business logic, i get the folling error (the second database is well configured and tested) :

       

      140 ERROR [org.hibernate.util.JDBCExceptionReporter] (Thread-70) javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1f26f44[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@42e68a connection handles=0 lastUse=1360755693140 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2d7c84 pool internal context=SemaphoreArrayListManagedConnectionPool@ccc170[pool=MySQLDS] xaResource=LocalXAResourceImpl@afd5d0[connectionListener=1f26f44 connectionManager=6d94ee warned=false currentXid=null] txSync=null]

      06:42:06,718 WARN  [org.hibernate.util.JDBCExceptionReporter] (Thread-70) SQL Error: 0, SQLState: null

      06:42:06,718 ERROR [org.hibernate.util.JDBCExceptionReporter] (Thread-70) javax.resource.ResourceException: IJ000460: Error checking for a transaction

       

      Any help please?

       

      Thanks.