Update: I made a mistake in my code. Please ignore this post.
-----------------------------------------------------------------------------------------------------


Hello,

I'm using the MySQL5InnoDBDialect. I found that if I set hbm2ddl.auto to create, tables will be created with innodb engine. But if I set hbm2ddl.auto to update, most tables will be created with myisam engine and few of them used innodb engine.

Questions:

1. May I use hbm2ddl.auto=update and still get tables created with innodb engine?

2. If hbm2ddl.auto=update, what's the logic beneath? Why some tables use Myisam and some uses innodb?

Thanks a lot,
Kevin