Hi,

I have 20 tables in my DB.

Can i make the storage engine type as InnoDB for some tables and MyIsam for other tables.

AFAIK Hibernate provides 2 different dialects for innodb and myisam. But how would i work with both the types at a time. In that case which dialect should i use ?

MySQL version 5.x

Thanks in advance,
Venu

Hi,

If you simply put the org.hibernate.dialect.MySQL5Dialect
it should work with both engine.

Thanks Eric.
We are using using annotations to generate the DDL thru hbm2ddl. How can i specify the engine type in the POJO so that i can specify the engine type as per my wish.

Thanks
Venu

I don't use annotation, but I dont think you can specify it in the annotation.
You should do it in the Hibernate.cfg.xml file.
You can also do it with code :

"Configuration cfg = new Configuration()
.addClass(org.hibernate.auction.Item.class)
.addClass(org.hibernate.auction.Bid.class)
.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLInnoDBDialect")
.setProperty("hibernate.connection.datasource", "java:comp/env/jdbc/test")
.setProperty("hibernate.order_updates", "true");"

As far as I know, there is no annotation which does this. In my project I also use annotations (JPA) and I generate the DDL with Ant and hibernate.cfg.xml; in this file I have this line:


And this has the desired effect:



Is this what you are looking for?