1 Reply Latest reply on Dec 23, 2001 3:09 AM by Angel Carrano

    Unable to persist over INNODB tables in MySQL

    Michael Newbie

      Hi All,

      I was running Jboss2.2.2 with MySQL. Everything ran fine with MySQL using default table-type "MyISAM"; however, when I switched to use "InnoDB" table-type. I was allowed to retreive data from those tables only but when I call "Create", I didn't receive any exception and neither the data being persisted in the tables.

      I hope someone can give me some help/suggestion. In addition, if someone who has sussessfully using "InnoDB" with JBoss for transaction, would you mind sharing the ways to get them to work??

      Greatly appreciated for any help/suggestion.


        • 1. Re: Unable to persist over INNODB tables in MySQL
          Angel Carrano Newbie

          I have seen this behavior when the EJB's transaction attribute is not set to "Required" (on your ejb-jar.xml file). You can set it to "Required" (as shown in the example below) and that should store the EJB on your table.




          This is not a very good solution since setting this attribute to Required on all of your entity EJB's may reduce performace.