Hello Kyle Please Help: I have spent a long time with this issue and am under tight timelines...
I have an web application (Non EJB) that based on servlets, JSP, struts, and Hibernate, and Oracle 9i. The application works fine in Tomcat 4.1.x. However when I deploy in Websphere (I am deploying a manually created war file without using WSAD) I notice the following:
1) All reads from the database are working fine 2) Inserts work first time and fail on second time and subsequent times 3) I see the following error messages:
javax.servlet.ServletException: LocalTransaction rolled-back due to setRollbackOnly at com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvok (WebAppTransactionCollaborator.java:224) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:671) ...
It is accompanied by:
WLTC0033E: Resource jdbc/cdb rolled back in cleanup of unresolved LocalTransactionContainment.
WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback
1) Why is WAS trying to rollback transaction? 2) How can I disable this so I have full control of transaction? 3) Has anyone deployed a simple webapp (Non-EJB) app using hibernate, WAS, and Oracle? If so please atleast guide me...