I am using straight forward jdbc call only.
If I am not going to use the set autocomit false. By default the setAutoComit is true and after each query execution, it will commit. For ex. I have four separate insert statement. If I am not using the setAutocomit false initially, then after every single insert statement,
jboss will call the commit. In this scenario, if I have an exception occurred in the four the insert statement. I cannot rollback the first three inserts which are already committed. What I really want is if the exception occurred in the forth insert, it should roll back all the four.
Hope you understood my problem.
Regards
Harikrishnan