MysqlXAException: No operations allowed after connection closed [message #1693396] |
Thu, 23 April 2015 14:16  |
Eclipse User |
|
|
|
Hi
Would somebody be able to share a mysql configuration file that works for Stardust 2.1.1 ? I am testing a 2.1.1 build for a development environment; however, I am experiencing frequent random disconnects and see below errors in tomcat log.
I also would be interested in the associated tomcat 7 server.xml entry for Resource AuditTrail.DataSource deployed on RH 6. My local 5.1 mysql db is started with storage engine innodb.
I DID follow instructions found at
http://help.eclipse.org/luna/topic/org.eclipse.stardust.docs.deployment/html/audittraildatabasesetup/mysql.html
Logon to portal and even remote Rest web service call to start business process works again ONLY once completely recycled. If no solution found I may need to switch to another db such as Oracle 11g which given the outdated InnoDb storage engine might be probably advisable to do but more costly. Additional question here would be is it possible to configure Stardust with an external JMS provider such as ORACLE AQ ? (Following works since done with ActiveMQ https://wiki.eclipse.org/Stardust/Knowledge_Base/Deployment/SpringConfigurations )
06:33:54 WARN [080-exec-8] Transaction - Unable to enlist XAResource
org.apache.geronimo.transaction.manager.WrapperNamedXAResource@784edc97, errorCode: 0
com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.start(WrapperNamedXAResource.java:111)
at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:202)
at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:60)
at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:101)
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.08081 seconds