Jboss don't create innodb tables

[tonisoler]

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.

[niox]

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