Thanks Erno, I didn't know about that option. I think that's exactly what
I'll do. I prefer it that way actually. To specify it on a per table basis
seems a bit weird to me. I would have figured that it would have at least
been specified at the database level.
Jon
----- Original Message -----
From: "Erno Mononen" <Erno.Mononen_at_Sun.COM>
To: <persistence_at_glassfish.dev.java.net>
Sent: Thursday, February 01, 2007 3:49 AM
Subject: Re: How to tell Glassfish Persistence to use TYPE = InnoDB when
creating MySQL tables?
> Hi Jon,
>
> Jon Miller wrote:
>> 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?
>
> Might not be an option for you, but it is possible to specify a default
> table type (e.g. "default-table-type=innodb") in your MySQL config file.
>
> Erno
>