Our application deployed on SAS 8.2 accesses remote Informix database using Connection Pool. Sometimes after couple of hours of normal work we are getting JTS5041 followed by RAR5029 and SAS stops to properly work
The application uses connection to a single database, no JMS etc is used.
What could be a reason? Most importantly how to prevent or avoid.
Was trying to set is-connection-validation-required property to true with no success.
<jdbc-connection-pool name="omcr3" steady-pool-size="2" max-pool-size="4" max-wait-time-in-millis="60000" pool-resize-quantity="2" idle-timeout-in-seconds="300" is-isolation-level-guaranteed="false" is-connection-validation-required="true" connection-validation-method="auto-commit" fail-all-connections="false" datasource-classname="com.informix.jdbcx.IfxXADataSource" res-type="javax.sql.XADataSource">
Appreciate any help!!!
Valery
---------
JTS5041: The resource manager is doing work outside a global transaction
javax.transaction.xa.XAException
at com.informix.jdbcx.IfxXAResource.start(IfxXAResource.java:464)
at com.sun.gjc.spi.XAResourceImpl.start(XAResourceImpl.java:162)
at com.sun.enterprise.resource.XAResourceWrapper.start(XAResourceWrapper.java:98)
....
RAR5029:Unexpected exception while registering component
javax.transaction.SystemException
at com.sun.jts.jta.TransactionImpl.enlistResource(TransactionImpl.java:193)
at com.sun.enterprise.distributedtx.J2EETransaction.enlistResource(J2EETransaction.java:397)
[Message sent by forum member 'azbelv' (azbelv)]
http://forums.java.net/jive/thread.jspa?messageID=283930