persistence@glassfish.java.net

How to tell Glassfish Persistence to use TYPE = InnoDB when creating MySQL tables?

From: Jon Miller <jemiller_at_uchicago.edu>
Date: Wed, 31 Jan 2007 15:42:37 -0600

Hi all,

I'm using Glassfish Persistence with a MySQL database. It's been awhile
since I've used MySQL and I seem to recall you need to add the "TYPE =
InnoDB" table option when creating a table if you want to use transactions
with it. I've used Hibernate in the past and there was a "dialect" that you
could use to tell it to use InnoDB rather than the default MyISAM. I'm
wondering if there is something similar in TopLink?

Jon