Hello,
I am getting the below error on Glassfish server
[b]java.sql.SQLException(Error in allocating a connection. Cause: java.lang.IllegalStateException: Wrong XAState: 0)[/b]
Stacktrace -
----------------------------------------------------------------------------------------------------------------------------
[#|2008-10-13T10:41:26.475-0400|SEVERE|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=23;_ThreadName=p: thread-pool-1; w: 9;_RequestID=e70b464f-c2de-4db1-a46b-f2e4860a2961;|RAR5027:Unexpected exception in resource pooling
java.lang.IllegalStateException: Wrong XAState: 0
at com.sun.jts.jta.TransactionState.startAssociation(TransactionState.java:323)
at com.sun.jts.jta.TransactionImpl.enlistResource(TransactionImpl.java:205)
at com.sun.enterprise.distributedtx.J2EETransaction.enlistResource(J2EETransaction.java:562)
at com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.enlistResource(J2EETransactionManagerImpl.java:372)
at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.enlistResource(J2EETransactionManagerOpt.java:169)
at com.sun.enterprise.resource.SystemResourceManagerImpl.enlistResource(SystemResourceManagerImpl.java:98)
at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:216)
at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:327)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158)
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108)
|#]
[#|2008-10-13T10:41:26.479-0400|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=23;_ThreadName=p: thread-pool-1; w: 9;_RequestID=e70b464f-c2de-4db1-a46b-f2e4860a2961;|poolmgr.err_enlisting_res_in_getconn|#]
[#|2008-10-13T10:41:26.479-0400|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=23;_ThreadName=p: thread-pool-1; w: 9;MyDataSource;java.lang.IllegalStateException: Wrong XAState: 0;_RequestID=e70b464f-c2de-4db1-a46b-f2e4860a2961;|RAR5117 : Failed to obtain/create connection from connection pool [ MyDataSource ]. Reason : java.lang.IllegalStateException: Wrong XAState: 0|#]
[#|2008-10-13T10:41:26.480-0400|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=23;_ThreadName=p: thread-pool-1; w: 9;Error in allocating a connection. Cause: java.lang.IllegalStateException: Wrong XAState: 0;_RequestID=e70b464f-c2de-4db1-a46b-f2e4860a2961;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: java.lang.IllegalStateException: Wrong XAState: 0]|#]
[#|2008-10-13T10:41:26.482-0400|INFO|sun-appserver9.1|javax.enterprise.system.container.ejb|_ThreadID=23;_ThreadName=p: thread-pool-1; w: 9;EventNote;|EJB5018: An exception was thrown during an ejb invocation on [EventNote]|#]
----------------------------------------------------------------------------------------------------------------------------
[b]I am using Oracle database. The resource type of JDBC Connection Pool is "javax.sql.ConnectionPoolDataSource" and the driver class used is "oracle.jdbc.driver.OracleDriver"[/b]
Can anyone please let me know how this error can be resolved?
Thanks in advance...
[Message sent by forum member 'myjavahelp' (myjavahelp)]
http://forums.java.net/jive/thread.jspa?messageID=306107