Re: StoredProcedures triggered by the model
Re: StoredProcedures triggered by the model
- Subject: Re: StoredProcedures triggered by the model
- From: Florijan Stamenkovic <email@hidden>
- Date: Mon, 14 May 2007 21:14:08 +0200
Hi Robert,
1. Is this the technique you are using to trigger your stored
procedures:
http://developer.apple.com/documentation/WebObjects/UsingEOModeler/
6WorkingWithEntities/chapter_6_section_5.html#//apple_ref/doc/uid/
TP30001018-CH206-BABGBCJE
Yes. Ever used that approach? Did it work for you?
2. Are your stored procedures doing something more complex than
assigning a simple incrementing integer primary key? I'm only
asking in case you are unaware that OpenBase provides a plug-in for
supporting native primary key generation. You can specify the
OpenBasePKPlugIn in your connection dictionary, and include the
OpenBasePKPlugin framework in your project. Doing so will
eliminate the need for the EO_PK_TABLE and have OpenBase provided
PKs natively to EOF.
Yes, they are generating IDs relative to a relationship. Nothing very
complex though, the stored procedure only does the following:
Statement s = connection.createStatement();
s.executeUpdate("UPDATE PUNCH_ITEM p1 SET UNIQUE_NUMBER =
(SELECT MAX(UNIQUE_NUMBER) FROM "+
"PUNCH_ITEM p2 WHERE p1.STRUCTURE_ITEM_ID = p2.STRUCTURE_ITEM_ID)
+ 1 WHERE UNIQUE_NUMBER = NULL");
return null;
Flor
_______________________________________________
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