A few things: 1) iBATIS never uses AutoCommit.
2) setCommitRequired has nothing to do with AutoCommit. iBATIS uses deferred commits to avoid unecessary commits when no non-queries have been issued. And setCommitRequired is actually parameterized and can be set with <transactionManager ... commitRequired="true"> 3) You'll need to post your code so we can see what it's doing. Are you calling startTransaction()? Are you using setUserConnection? Or openSession(conn)? I'm sure with the right information we can resolve this for you easily. Clinton On 1/18/07, Yuvraj Shinde <[EMAIL PROTECTED]> wrote:
Hi all, I want to know how to handle auto commit in ibatis.if I am saving two records and if I get an exception while saving second record the first record saved should be rolled back. But ibatis is saving the first record. How I should handle this even though the auto commit property is explicitly set to false. Even though AutoCommit value is set to false. Rollback of Transaction is not working. I found one Issue in GeneralStatement.java. On line 52 request.getSession().setCommitRequired(true); Here Auto commit is hard coded it should be parameterized so that it will take value from "Auto commit" property of SqlMapConfig.xml. Please correct me if I am wrong.please send me a solution. Regards Yuvrajs Yuvraj Shinde • Senior Software Engineer - Zainet• SunGard • Offshore Services • Pride Portal,CTS No 103A/5A/1A/1B Bhamburda,Senapati Bapat Road, shivajinagar,Pune 411016 Tel Direct +91 20 66248045 • Main +91 20 66248000 • Fax +91 20 25606222 [EMAIL PROTECTED] • www.sungard.com Success is never ending and failure is never final.
