Community » Forums » Hibernate - General > Trouble with syntax/dialect with Hibernate and MySQL 6
July 13, 2010 2:33:42 PM PDT (7 weeks ago). Seen 60 times.
Photo Broc Nelson
Software Developer
CFCU
Member since Jun 2, 2010
Location: Brookings
Posts: 2
I got all my environment setup with MySQL 6 and got syntax errors from Hibernate on startup. Rolled back to MySQL 5.1 and it worked fine. Is there another dialect to fix this? Currently using the org.hibernate.dialect.MySQLInnoDBDialect. Am i doing something wrong?

App working fine with 5.1, just wondering about the problems with MySQL 6.

Thanks,
Broc
Edited 2 times. Last edit by Broc Nelson on Jul 14, 2010 at 10:49:19 AM (about 11 weeks ago).
July 14, 2010 10:47:02 AM PDT (7 weeks ago)
Photo Aleksandar Gargenta
Partner
Marakana, Inc.
Member since Jan 19, 2007
Location: San Francisco
Posts: 78
Broc,

MySQL 6 is still alpha. I've never used it, and I don't expect that you'll see Hibernate officially support it until it goes GA. You may even get org.hibernate.dialect.MySQLInnoDBDialect to work, but Hibernate is complex enough that you probably don't want to introduce more variables into its workflow.

Cheers,
Sasa
Edited one time. Last edit by Aleksandar Gargenta on Jul 14, 2010 at 10:47:21 AM (about 11 weeks ago).
July 14, 2010 10:49:19 AM PDT (7 weeks ago)
Photo Broc Nelson
Software Developer
CFCU
Member since Jun 2, 2010
Location: Brookings
Posts: 2
Gotcha. Didn't know MySQL 6 was THAT new! Appreciate the quick feedback. Thanks again for a GREAT course!

Cheers,
Broc