Re: PK Generation in MySQL
Re: PK Generation in MySQL
- Subject: Re: PK Generation in MySQL
- From: Robert Walker <email@hidden>
- Date: Thu, 18 May 2006 17:51:14 -0400
The easiest way I see is to let MySQL generate the keys itself.
How could I
As far as I know you cannot let MySQL generate the keys itself, at
least not in the way you're probably thinking. I really don't think
EOF has any support for native PK generation with MySQL.
On May 18, 2006, at 4:26 PM, Randy Wigginton wrote:
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:
40gmail.com
This email sent to email@hidden
--
Robert Walker
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