Hello guys
(sorry for my grammar)

in these days i did an updagrade from mysql 4.13 to mysql 5.0.27

and now in my java application i change the dialect for Hibernate to MySQL5InnoDBDialect

i have a big doubt
what is really the difference between
MySQL5Dialect and MySQL5InnoDBDialect ???

i saw this link
http://www.hibernate.org/hib_docs/v3/ap ... mmary.html

and if i see each class, i only see a simple "extension" of classes, no more explanation

is there some documentation for this???

thanks for advanced

InnoDB dialect emmits the InnoDB attributes for DDL generation. This is for setups where the DB may not default to InnoDB storage.

hello David

thanks for your reply



i am not expert in this scope, and your explanation was short (dont take this how an ofense), but when i should choice each dialect???, i need a real example or more details

thanks for advanced

You want to have transactional tables, InnoDB being one possible choice, when using MySQL. My understanding is that its on by default (from MySQL 4.x). The only difference are the SQL commands that are generated to create the tables etc. The InnoDB dialect forces the InnoDB tables thus they are transactional - as required by Hibernate. So which should you use - MySQL 5 should not matter as the DB defaults (unless someone changed the DBs default configuration). So to make sure use the InnoDB form of the dialect.