1 Reply Latest reply on May 14, 2003 5:55 AM by Nikos Paraskevopoulos

    Jboss don't create innodb tables

    tonisoler Newbie

      jboss don't create innodb tables, when i deploy some ejbs jboss creates some myisam tables then when aplies the foreign key don't work.

        • 1. Re: Jboss don't create innodb tables
          Nikos Paraskevopoulos Newbie

          When MySQL creates a table with a SQL statement like:

          CREATE TABLE tbl_name (create_definition,...)

          it uses the default table type, which is MyISAM. In order to create InnoDB tables either you specify the table type explicitly in the create statement like:

          CREATE TABLE tbl_name (create_definition,...) TYPE=InnoDB

          or change the default table type to InnoDB by specifying the command line option "--default-table-type=InnoDB" when starting the server.

          I am not sure how to instruct JBoss to use the first option when automatically creating tables, so I myself am using the second option.

          Best regards,
          Nikos