Re: Error with ID in EOModeler
Re: Error with ID in EOModeler
- Subject: Re: Error with ID in EOModeler
- From: Chuck Hill <email@hidden>
- Date: Sun, 18 Apr 2004 08:15:44 -0700
The error is yours. :-) When manually adding data you need to use the
same PK generation scheme that EOF is using. I think that mySQL uses
the EO_PK_TABLE method. You need to ensure that you update it when
inserting data.
Chuck
On Apr 18, 2004, at 6:43 AM, Ute Hoffmann wrote:
Hallo,
I experienced a problem when adding some entries to a database via the
commandline without EOModeler or the JDBC-Adaptor knowing what was
going on in the database.
When adding new data directly from the database interface the next
time one tries to enter data from the WebObjects interface EOModeler
or the adaptor/db create an error that the id it tries to assign to
the new entry does already exist. It seems that WebObjects knows about
the last id it created and tries to assign a new id which is one
higher than the last one it created. If there are additional database
entries made from the database interface the id EOModeler/the adaptor
creates is already there.
Is there a way to make WO check, what is the last id in the table and
create a new higher one and not using a value it knows about as the
last id?
Would stopping and restarting the app help?
My Database is MySql, if that is of any importance and I use the
mmmysql adaptor.
Thanks for some input,
Regards,
Ute
_______________________________________________
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.
_______________________________________________
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.