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.