When we had this situation, we ended up making external apps do it the EO_PK_TABLE way. We logged the SQL to see exactly the statements EOF used to generate PKs and created a subroutine in the non-WebObjects app that used the same SQL pattern as EOF to get a PK from the EO_PK_TABLE. I forget now, but it was only 2 or 3 lines of SQL ...

In any case, you could implement your own PK generation delegate and provide them whatever way you want
http://developer.apple.com/documentation/WebObjects/Enterprise_Objects/Saving/chapter_8_section_7.html#

YMMV, Kieran

BTW, make sure you do not use MyISAM tables with your WebObjects apps. Use InnoDB to ensure transaction commit/rollback of editing context saves.


On Oct 4, 2008, at 1:32 AM, Richard Stephens wrote:

Hi

Is there any way to get round having to use EO_PK_TABLE for mysql and to allow WO to use auto_increment instead? I'm writing a WO app that has to share a mysql database with a number of PHP apps, so the data that ends up in EO_PK_TABLE can't be trusted.

Regards,
Richard Stephens
Ph: 07 3136 3426
Mob: 0410 111 570
Email: [EMAIL PROTECTED]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com

This email sent to [EMAIL PROTECTED]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to