Re: PK Generation in MySQL
Re: PK Generation in MySQL
- Subject: Re: PK Generation in MySQL
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 18 May 2006 23:20:12 -0400
FYI, All that is required for EO PK to be a transactional table is to
"alter table mytable engine=innobd;" or something like that. See
ALTER TABLE syntax. Also Innodb can be set as the default table type
for the server in the /etc/my.cnf properties file.
-Kieran
On May 18, 2006, at 3:03 PM, Anjo Krank wrote:
Am 18.05.2006 um 20:24 schrieb Robert Walker:
Generally PK generation is a function EOF not MySQL. There are
plug-ins that support database native PK generation, as is the
case with "OpenBasePKPlugIn." but I'm not aware of anything
similar for MySQL.
In any case, unless you're using something special, this problem
likely has nothing to do with MySQL. The problem would exist no
matter what data store is used.
The problem is most likely because the default EOF pk generation
doesn't use the table type for mysql that support transactions. Way
back when I was using mysql, I was overriding the PK gen by
wrapping it with "LOCK TABLES;"..."UNLOCK TABLES;" or sth like it.
Cheers, Anjo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden