I followed all instructions to configure bonitasoft for SQL server. When I start bonitasoft the tables in the database are created (which proves that the credentials and permissions are okay). However, I keep getting the same error after the tables have been created.
Mar 05, 2014 6:25:00 PM bitronix.tm.recovery.Recoverer recoverAllResources
WARNING: error running recovery on resource 'jdbc/bonitaDSXA', resource marked as failed (background recoverer will retry recovery) (error=XAER_RMERR)
javax.transaction.xa.XAException: The function RECOVER: failed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
Then after all the factory beans have been loaded, I get the following error:
WARNING: Could not obtain connection to query metadata
java.sql.SQLException: unable to get a connection from pool of a PoolingDataSource containing an XAPool of resource jdbc/bonitaDSXA with 1 connection(s) (1 still available) -failed-
I guess it is some kind of bitronix issue. But the error message makes no sense to me. You cannot get a connection, but there is a connection available. I even tried to change the minPoolSize to 5, which just leads to the error ...with 5 connection(s) (5 still available).
Can anyone point me to a solution for this problem.
Full catalina.out can be found here: