• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: PK Generation in MySQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >PK Generation in MySQL (From: "Randy Wigginton" <email@hidden>)
 >Re: PK Generation in MySQL (From: Robert Walker <email@hidden>)
 >Re: PK Generation in MySQL (From: Anjo Krank <email@hidden>)

  • Prev by Date: Re: Setting a Default toOne Relationship
  • Next by Date: WO 5.3 and Tomcat property files?
  • Previous by thread: RE: PK Generation in MySQL
  • Next by thread: DB connection failing.
  • Index(es):
    • Date
    • Thread