Hi,
Thanks in advance for your inputs/suggestions.
Since last two days i am facing the issue with Spring transaction rollback. i am using
Tomcat 5.5.28 and Spring. Basically i want to handle transaction with spring, in Tomcat environment. I am using Sybase ASE 12.5 as my back-end database.
I have defined database connection under Tomcat_Home/conf/context.xml.
Everything seems working fine, but I am facing the issue on property 'defaultAutoCommit' under Tomcat_Home/conf/context.xml
Please find below scenarios.
1. if defaultAutoCommit="false" ---> then on successfull execution also its not saving data into backend table.
2. if defaultAutoCommit="true" ---> then on RunTimeException also its not doing RollBack. and updating back-end table.
Anyone please guide me how should i handle the situation,
Please find below code.
Tomcat_Home/conf/context.xml
Java class - CustUtilities.java
applicationContext-jdbc2.xml
JSP/Servlet class from where i call the testSpring() method.
Please provide me your suggestions.
Thanks,
Ronak.