JPA, Hibernate, How to specify database engine for MySQL datasource?

[dhileman]

Hello all,

I have a JPA project, using a Wildfly 8 configured JTA MySQL Cluster datasource.  The problem I am having is, when my entity tables are created, they are only being created on one data node in my 2-node DB cluster. 

Is there a way to specify the DB engine for JPA to use to create the tables?  If I log in to the MySQL server and enter the statement directly, while specifying the engine, the table is created on both DB nodes correctly:

CREATE TABLE Person ENGINE=NDBCLUSTER;

Is there any known hibernate property that goes in persistence.xml to specify engine? Or in the Wildfly datasource?

Is there a special sql dialect for using NDBCLUSTER.  I have only seen the following dialects documented for MySQL:

MySQL5Dialect

MySQL5InnoDBDialect

MySQLDialect

MySQLInnoDBDialect

MySQLMyISAMDialect

Thanks

[smarlow]

It looks like MySQL5InnoDBDialect uses "ENGINE=InnoDB" and MySQL5Dialect does not.  With MySQL5Dialect, I think that you should get the default MySQL storage engine.

MySQL also has configuration settings (database and server level) for the default storage engine which would be used if no storage engine is specified for the created database or table.  See https://dev.mysql.com/doc/refman/5.1/en/storage-engine-setting.html

[dhileman]

Thank you, I just needed to set the default engine setting to NDBCLUSTER.  I found an alternative solution, where I created a custom dialect class by extending the MySQL5Dialect class, but the solution you suggested is much better for my project.