2 Replies Latest reply on Jan 14, 2005 3:58 PM by Geoff Seel

    Container Managed Transactions and MySQL/InnoDB

    Geoff Seel Newbie

      I am trying to add some transaction management to a JBoss 3.2 + MySQL/InnoDB system. The system uses Stateless Session EJBs and purpose written DAOs. All methods of the EJBs have Required option for Transactions.

      I have written a test method that does two inserts into a table, the second of which causes an SQLException. The behaviour I want is for the first insert to be rolled back but this doesn't happen.

      Could this be because AUTOCOMMIT is turned on by default? If so how do I set things up so that it is not turned on? If not, does anyone have any ideas what else I may have overlooked?