I'm using MySQL 5 with MyISAM engine to persisting POJO. Now I would like to assign MySQL specific table creation options to create tables (namely the [b]DATA DIRECTORY [/b]and [b]INDEX DIRECTORY [/b]options) by Hibernate Annotation.

But I can't find any solution for that, can anybody teaching me how to do that ?


[b]Hibernate version:3.2, Annotation:3.3[/b]

[b]Name and version of the database you are using:MySQL 5.0.x[/b]

you'll need to generate the DDL file and change it manually

I realize that passing database specific option from Hibernate to database engin is not included in current release. But how about add a parameter into @Entity annotation while mapping a class to table for including such options concatenated to the end of the table creation statement ? Of course user who use this facility takes the risk by himself.

Sounds hacky to me and specific to MySQL