Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > J2EE
|
J2EE General J2EE (Java 2 Enterprise Edition) discussions. Questions not specific to EE will be redirected elsewhere.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the J2EE section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 12th, 2004, 02:47 PM
Authorized User
 
Join Date: Jul 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default TRANSACTION_ENDING Exception

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

 
Old April 7th, 2004, 11:21 AM
Registered User
 
Join Date: Apr 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

 
Old August 12th, 2004, 02:14 PM
Authorized User
 
Join Date: Jul 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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


Quote:
quote:Originally posted by suri
 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


 
Old August 23rd, 2004, 02:21 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

AbstractSAXParser.java:1194

Can you paste the code for the ref.


 
Old August 23rd, 2004, 02:24 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

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.


 
Old May 22nd, 2006, 11:35 AM
Registered User
 
Join Date: May 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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))





Similar Threads
Thread Thread Starter Forum Replies Last Post
COM Exception muralidharan.d VS.NET 2002/2003 0 August 7th, 2007 02:49 PM
BindingNavigator Exception osorio.agustin Visual Basic 2005 Basics 0 March 13th, 2007 08:39 PM
Exception Ochi C# 1 January 15th, 2006 11:38 PM
TRANSACTION_ENDING error suri Java Databases 6 February 7th, 2005 08:14 PM
TRANSACTION_ENDING error suri Java GUI 0 March 12th, 2004 12:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.