Search code examples
mysqlspring-boottransactionsspring-transactionsautocommit

Spring Boot + Mysql + TransactionManager

I want to manage the mysql transactions by my own using PlatformTransactionManager and @Transactional but it doesn't work.On other hand,when i work on oracle database it work effectively as per my requirement but in mysql unable to control transactions. Also turn off the mysql autocommit default setting to zero but still face that problem.

Solution

  • Hey guys I found the solution,I change the mysql engine from MyISAM to InnoDB.Now its work fine.For more detail about mysql engine follow the link :-

    dev.mysql.com/doc/refman/5.7/en/storage-engines.html