Key Creation & EO
Key Creation & EO
- Subject: Key Creation & EO
- From: Lotsa Cabo <email@hidden>
- Date: Mon, 12 Jul 2004 07:08:45 -0400
On Jul 10, 2004, at 9:48 PM, Scott Keith wrote:
> The database actually generates the key in this case (not the
> framework/plugin). However, the plugin does send the NEWID command to
> the server to generate the key. If you don't use the plugin then EO
> sends a select statement to get the seed value in the EO_PK_TABLE, it
> adds 1 to it, and then updates the table. That is the default
> behavior which our plugin overrides.
Holy ___ ! Is this correct!?!?!
I posted a question to the OpenBase list asking what creates the
primary key, OpenBase or EO. The reply I got is above and, well,
sucks! If the default logic within EO is this two-step process of
issuing a SELECT for the current ID and then incrementing the ID just
to return it, then what prevents another instance of the application
from using the same ID BEFORE the first one has an opportunity to get
inserted?
Also, Scott mentioned a plugin that overrides this. I've never heard
of any plugin mentioned anywhere... at least, not in any of the books
I've read. Where can one find such a plugin? And, if OpenBase
provides the plugin, then what about all of the other databases out
there?
Talk to me, Goose.
Thanx,
Ryan
_________________________
Tired of spam? Signup for a FREE SpamJammer.Com account and say
goodbye to junk email forever!
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.