uday_kulk
asked on
URGENT : Servlet Web Application is stuck between transaction
Hello
I deployed servlet web application in IBM Websphere 6.0 and set the IBM DB2 V8 data source as DB2 Universal JDBC Driver Provider and it works fine. I am able to logon successfully.
I am not using EJB in my application.
I am using simple servlet jsp.
Operating System : Windows 2003 Server Ent. Edi.
Problem : My appication is not work consistent it is stuck between transaction and I encountering the following rollback and transaction error in SystemOut.log
SharedPool I Shareable connection MCWrapper id 3665270d Managed connection WSRdbManagedConnectionImpl @2b36a70d State:STATE_TRAN_WRAPPER_I NUSE
from resource jdbc/ss_webdb was used within a local transaction containment boundary.
WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen t.
Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainmen t.
Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainmen t.
[5/12/05 18:00:39:125 IST] 0000002e LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen t.
[5/12/05 18:00:39:266 IST] 0000002e SystemOut O Class : JHMnBean, m_objConnection is not null: OCT5
[5/12/05 18:00:39:266 IST] 0000002e SystemOut O Class : JHMnBean, m_objConnectionBilling is not null: OCT05
[5/12/05 18:00:39:266 IST] 0000002e SystemOut O
[5/12/05 18:00:39:281 IST] 0000002e ServletWrappe A SRVE0242I: [/jsp/ErrorLogin.jsp]: Initialization successful.
[5/12/05 18:00:39:297 IST] 0000002e SystemOut O USLogin_Main.jsp
[5/12/05 18:00:39:297 IST] 0000002e ServletWrappe A SRVE0242I: [/jsp/USLogin_Main.jsp]: Initialization successful.
[5/12/05 18:00:39:359 IST] 0000002e LocalTranCoor W WLTC0033W: Resource jdbc/ss_billdb rolled back in cleanup of LocalTransactionContainmen t.
[5/12/05 18:00:39:359 IST] 0000002e LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen t.
[5/12/05 18:00:39:406 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/top_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:406 IST] 0000002f ServletWrappe A SRVE0242I: [/jsp/title_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:422 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/IncCommon.jsp]: Initialization successful.
[5/12/05 18:00:39:438 IST] 0000002e ServletWrappe A SRVE0242I: [/jsp/Wait_Screen.jsp]: Initialization successful.
[5/12/05 18:00:39:453 IST] 0000002a SystemOut O SEQ : 0
[5/12/05 18:00:39:453 IST] 0000002e SystemOut O SEQ : 0
[5/12/05 18:00:39:469 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/IncHidden.jsp]: Initialization successful.
[5/12/05 18:00:39:516 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/left_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:516 IST] 0000002f ServletWrappe A SRVE0242I: [/jsp/bottom_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:531 IST] 0000002a SystemOut O SEQ : 0
[5/12/05 18:00:39:531 IST] 0000002f SystemOut O l_strMessages after reading CheckNewMessages()null
[5/12/05 18:00:46:031 IST] 0000002a SystemOut O Class : JHMnBean, m_objConnection is not null: OCT5
[5/12/05 18:00:46:047 IST] 0000002a SystemOut O Class : JHMnBean, m_objConnectionBilling is not null: OCT05
[5/12/05 18:00:46:047 IST] 0000002a SystemOut O
[5/12/05 18:00:46:047 IST] 0000002a SystemOut O SEQ : 27
LocalTranCoor W WLTC0033W: Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainmen t.
LocalTranCoor W WLTC0033W: Resource jdbc/ss_billdb rolled back in cleanup of LocalTransactionContainmen t.
[5/12/05 18:00:46:047 IST] 0000002a LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen t.
I tried to resolve this issue. Can anyone help on this.
Please try to resolve this issue asap. Very Urgent.
Regards&Thanks
udi
I deployed servlet web application in IBM Websphere 6.0 and set the IBM DB2 V8 data source as DB2 Universal JDBC Driver Provider and it works fine. I am able to logon successfully.
I am not using EJB in my application.
I am using simple servlet jsp.
Operating System : Windows 2003 Server Ent. Edi.
Problem : My appication is not work consistent it is stuck between transaction and I encountering the following rollback and transaction error in SystemOut.log
SharedPool I Shareable connection MCWrapper id 3665270d Managed connection WSRdbManagedConnectionImpl
from resource jdbc/ss_webdb was used within a local transaction containment boundary.
WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen
Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainmen
Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainmen
[5/12/05 18:00:39:125 IST] 0000002e LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen
[5/12/05 18:00:39:266 IST] 0000002e SystemOut O Class : JHMnBean, m_objConnection is not null: OCT5
[5/12/05 18:00:39:266 IST] 0000002e SystemOut O Class : JHMnBean, m_objConnectionBilling is not null: OCT05
[5/12/05 18:00:39:266 IST] 0000002e SystemOut O
[5/12/05 18:00:39:281 IST] 0000002e ServletWrappe A SRVE0242I: [/jsp/ErrorLogin.jsp]: Initialization successful.
[5/12/05 18:00:39:297 IST] 0000002e SystemOut O USLogin_Main.jsp
[5/12/05 18:00:39:297 IST] 0000002e ServletWrappe A SRVE0242I: [/jsp/USLogin_Main.jsp]: Initialization successful.
[5/12/05 18:00:39:359 IST] 0000002e LocalTranCoor W WLTC0033W: Resource jdbc/ss_billdb rolled back in cleanup of LocalTransactionContainmen
[5/12/05 18:00:39:359 IST] 0000002e LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen
[5/12/05 18:00:39:406 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/top_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:406 IST] 0000002f ServletWrappe A SRVE0242I: [/jsp/title_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:422 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/IncCommon.jsp]: Initialization successful.
[5/12/05 18:00:39:438 IST] 0000002e ServletWrappe A SRVE0242I: [/jsp/Wait_Screen.jsp]: Initialization successful.
[5/12/05 18:00:39:453 IST] 0000002a SystemOut O SEQ : 0
[5/12/05 18:00:39:453 IST] 0000002e SystemOut O SEQ : 0
[5/12/05 18:00:39:469 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/IncHidden.jsp]: Initialization successful.
[5/12/05 18:00:39:516 IST] 0000002a ServletWrappe A SRVE0242I: [/jsp/left_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:516 IST] 0000002f ServletWrappe A SRVE0242I: [/jsp/bottom_fr.jsp]: Initialization successful.
[5/12/05 18:00:39:531 IST] 0000002a SystemOut O SEQ : 0
[5/12/05 18:00:39:531 IST] 0000002f SystemOut O l_strMessages after reading CheckNewMessages()null
[5/12/05 18:00:46:031 IST] 0000002a SystemOut O Class : JHMnBean, m_objConnection is not null: OCT5
[5/12/05 18:00:46:047 IST] 0000002a SystemOut O Class : JHMnBean, m_objConnectionBilling is not null: OCT05
[5/12/05 18:00:46:047 IST] 0000002a SystemOut O
[5/12/05 18:00:46:047 IST] 0000002a SystemOut O SEQ : 27
LocalTranCoor W WLTC0033W: Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainmen
LocalTranCoor W WLTC0033W: Resource jdbc/ss_billdb rolled back in cleanup of LocalTransactionContainmen
[5/12/05 18:00:46:047 IST] 0000002a LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen
I tried to resolve this issue. Can anyone help on this.
Please try to resolve this issue asap. Very Urgent.
Regards&Thanks
udi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have to ask me about autoCommit, then it's set to "true" (on) :-) BTW, to turn it off you say conn.setAutocommit(false) ... but then you always have to do conn.commit() and conn.rollback() as necessary. Since it's true here, I don't think it's the issue.
Did you try the stuff in my second paragraph. Perhaps you could post the SQL code?
Did you try the stuff in my second paragraph. Perhaps you could post the SQL code?
ASKER
I am using WebSphere Application Server 6.0.
Yes. It is Update ans Select.
I am not using EJB.
Where is the option for autocommits set?
Can u guide me how do i resolve this problem using websphere application server 6.0..
Thanks & Regards
Uday