I am getting the below error, does any one know what could be the problem.

===============
EmsopsRespHandler::endElement com.equifax.emsops.business.common.EmsopsOpera
tionFailedException: FaxReqDAO:FaxReq:: java.sql.SQLException: DSRA9360E: Unable to perform the requested operation from the following transac
tion state: TRANSACTION_ENDING.
java.lang.RuntimeException: EmsopsRespHandler::endElement com.equifax.emsops.business.common.EmsopsOperation FailedException: FaxReqDAO:FaxReq:
: java.sql.SQLException: DSRA9360E: Unable to perform the requested operation from the following transaction state: TRANSACTION_ENDING.
        at org.apache.xerces.parsers.AbstractSAXParser.parse( AbstractSAXParser.java:1194)
        at.va.sql.SQLExceptionSQLException: DSRA9360E: Unable to perform the requested operation from the following transaction state: TRANSAC
TION_ENDING.
        at javax.xml.parsers.SAXParser.parse(Unknown Source)
        at com.equifax.emsops.business.facade.EmsopsMessageHa ndlerBean.faxResponseHandler(EmsopsMessageHandlerB ean.java:558)
        at com.equifax.emsops.business.facade.EJSRemoteStatel essEmsopsMessageHandler_45db8f79.faxResponseHandle r(EJSRemoteStatelessEmsopsMessa
geHandler_45db8f79.java:91)
        at com.equifax.emsops.business.facade._EmsopsMessageH andler_Stub.faxResponseHandler(_EmsopsMessageHandl er_Stub.java:393)
        at com.equifax.emsops.business.facade.EmsopsMessageLi stenerBean.onMessage(EmsopsMessageListenerBean.jav a:104)
        at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnM essage.run(MDBWrapper.java:205)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage( MDBWrapper.java:194)
        at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBW rapper.java:172)
        at com.ibm.mq.jms.MQSession.run(MQSession.java:1043)
        at com.ibm.ejs.jms.JMSSessionHandle.run(JMSSessionHan dle.java:922)
        at com.ibm.ejs.jms.listener.ServerSession.connectionC onsumerOnMessage(ServerSession.java:697)
        at com.ibm.ejs.jms.listener.ServerSession.onMessage(S erverSession.java:482)
        at com.ibm.ejs.jms.listener.ServerSession.dispatch(Se rverSession.java:449)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.ibm.ejs.jms.listener.ServerSessionDispatcher.d ispatch(ServerSessionDispatcher.java:37)
        at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrap per.java:91)
        at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrap per.java:127)
        at com.ibm.ejs.jms.listener.ServerSession.run(ServerS ession.java:372)
        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:593)
=======================

Thanks in-advance.
Suri

Did you ever find an answer to this? I am receiving the same SQLException, but this is the only place on the web - THE WHOLE WEB - that mentions it:

DAOException:DSRA9360E: Unable to perform the requested operation from the following transaction state: TRANSACTION_ENDING.

Our data access code is running within a loop - first does a read, performs calcs based on data read, and then does a write to the results table.

Thanks.

Hi all

Its me again...still facing the same problem. This time its happening very often. Can anyone help me out of this??

Thanks
Suri

AbstractSAXParser.java:1194

Can you paste the code for the ref.

http://p2p.wrox.com/topic.asp?TOPIC_ID=17653

The same error posted by earlier is solved or yet...
make sure the ResultSet declaration again.

We have an application based on ejbs.We have this error in our performance environment for a while.

We are caching connection at the bean instance level. We found that this error is caused when one of the not closed connection is resued by the bean instance for another transaction execution. As a immediate fix, we get a connection directly from the datasource and close it in method where this exception is thrown. But for a permanent solution we need to close all leaked connections.

Here is the stack trace:

>Exception 1:com.freedomgroup.common.exception.TFGSessionExce ption: getAddressDOs() failure: : SQL Error Code = 0 : MESSAGE = DSRA9360E: Unable to perform the requested operation from the following transaction state: TRANSACTION_ENDING. : SQL Error Code = 0 : MESSAGE = DSRA9360E: Unable to perform the requested operation from the following transaction state: TRANSACTION_ENDING.
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTr ansactionIfNecessary(WSJdbcConnection.java(Compile d Code))
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepare Statement(WSJdbcConnection.java(Compiled Code))
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepare Statement(WSJdbcConnection.java(Compiled Code))