RE: PK Generation in MySQL
RE: PK Generation in MySQL
- Subject: RE: PK Generation in MySQL
- From: "Randy Wigginton" <email@hidden>
- Date: Thu, 18 May 2006 16:26:52 -0400
Can you give any hints about how you wrapped the PK Gen?
The easiest way I see is to let MySQL generate the keys itself. How could I
go about that? Ie, create table myTable (id int not null auto_increment,
other cols) and then turn off EOF PK generation. Does that seem like a good
alternative, but then EO would not know what the PK is.
-----Original Message-----
From: webobjects-dev-bounces+cawineguy=email@hidden
[mailto:webobjects-dev-bounces+cawineguy=email@hidden] On
Behalf Of Anjo Krank
Sent: Thursday, May 18, 2006 3:03 PM
To: Robert Walker
Cc: Development WebObjects
Subject: Re: PK Generation in MySQL
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:
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