Re: StoredProcedures triggered by the model
Re: StoredProcedures triggered by the model
- Subject: Re: StoredProcedures triggered by the model
- From: Robert Walker <email@hidden>
- Date: Mon, 14 May 2007 15:30:44 -0400
Yes. Ever used that approach? Did it work for you?
Sorry, no I've not ever tried it myself. I try to limit myself to simple integer PKs (except in extreme circumstances like when dealing with legacy system, which in my case stored procedures we're practical anyway).
Yes, they are generating IDs relative to a relationship. Nothing very complex though, the stored procedure only does the following:
I assumed that was the case, but just wanted to verify.
Sorry I couldn't help further, but I don't really understand why that technique didn't work for you. Unless, stored procedures are somehow broken in the latest version of WO. I can't imagine that's true though. On May 14, 2007, at 3:14 PM, Florijan Stamenkovic wrote: Hi Robert,
1. Is this the technique you are using to trigger your stored procedures:
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