Friday, December 13, 2013

Spring Transaction Management with Mysql Rollback is not working


Yesterday i had struggle with 'Spring Transaction management'  that i am not able to Rollback Transaction.Now I Found the solution in My case...
 
In Mysql Database the 'MyISAM' Engine do not have transactions. So no matter how you configure spring or native JDBC without Spring or use JTA or Hibernate, you can never get a ROLLBACK.                                                            

In My case the Problem is ..
"My Database Table has 'MyIsam'  Engine and I Changed it to 'InnoDB' and then The 'Rollback' Worked Fine".

and one more possible solution is Try  set auto commit false.

0 comments:

Post a Comment