|
Home > Archive > WebSphere Application Server > May 2005 > Connection Pool is getting rolled back
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connection Pool is getting rolled back
|
|
|
| I have deployed 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 and Java beans.
Operating System : Windows 2003 Server Ent. Edi.
Problem : My application is not consistent it gets stuck between transactions. I am 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_INUSE
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 LocalTransactionContainment.
Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainment.
Resource jdbc/ss_webdb rolled back in cleanup of LocalTransactionContainment.
[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 LocalTransactionContainment.
[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 LocalTransactionContainment.
[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 LocalTransactionContainment.
[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 LocalTransactionContainment.
LocalTranCoor W WLTC0033W: Resource jdbc/ss_billdb rolled back in cleanup of LocalTransactionContainment.
[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 LocalTransactionContainment.
Can anyone help on this?
Please try to resolve this issue asap. Very Urgent.
Thanks,
Yashovardhan
| |
| David Currie 2005-05-19, 7:49 am |
| A LocalTransactionContainment is what you get in the absence of a global
(XA) transaction. The message indicates that you performed some local
transaction work as part of that containment scope (method or activity
session) and then did not commit. The default behaviour (controlled by
unresolved-action) is to rollback any uncommited work at the end of
the scope. You have a number of options:
- Explicitly commit the local transaction
- Change the data source to use auto-commit
- Place the work within a global transaction
- Change the unresolved-action to commit
Regards,
David
| |
|
| Hey David,
Could you please explain how each of the following actions is performed? I am new to RAD and finding good help has been extremely difficult.
I'm using RAD 6.0. I have a .jsp that is supposed to INSERTs records but always fails with the LocalTransactionContainment rollback message. My SELECT .jsp works fine.
- Explicitly commit the local transaction
- Change the data source to use auto-commit
- Place the work within a global transaction
- Change the unresolved-action to commit
Sincerely,
Robert Spear
| |
| David Currie 2005-05-31, 7:49 am |
| > Explicitly commit the local transaction
connection.commit(); // after the work has been performed
> Change the data source to use auto-commit
connection.setAutoCommit(true); // before the connection is used
> Place the work within a global transaction
Context ic = new InitialContext();
UserTransaction ut =
(UserTransaction) ic.lookup("java:comp/UserTransaction");
ut.begin();
// use connection here
ut.commit();
> Change the unresolved-action to commit
Select the 'Servlets' tab on the deployment descriptor editor and then
select the servlet in question. Under 'WebSphere Extensions' and then
'Local Transaction' set the 'Unresolved Action' to 'Commit' from the
drop-down menu.
Regards,
David
|
|
|
|
|