Re: App stuck on executeStoredProcedure()
Re: App stuck on executeStoredProcedure()
- Subject: Re: App stuck on executeStoredProcedure()
- From: David den Boer <email@hidden>
- Date: Tue, 5 Feb 2008 11:03:24 -0800
Ok, here is a screenshot of one of my stored procs (sorry Mike, the
pic is from EOModeler because it was quicker to open than eclipse for
a quick screenshot :-) )
Attachment:
Picture 2.png
Description: application/applefile
The name is just my own internal name for things -- I use when
binding my parameters via a dictionary.
The Column is the database side for the stored procedure parameters.
in this case, the output is just a String, so there is one out
parameter, with Column of 000. The first parameter in my stored
procedure has a Column of 001, and so on. That is how you get the
order of things correct.
Hope this helps.
On Feb 1, 2008, at 12:23 PM, Mike Schrag wrote:
They should be three digit numbers?!? I don't understand.
Are you saying to ignore what the _actual_ parameter names are,
just name them whatever ti takes to get them in the right order?
Yes. I believe the order of stored proc parameters must be in the
same order as the sorted list of EOArguments defined for the
storedproc in the model. Additionally, I believe the columns
coming back must be in the correct order of the attributes of the
entity you're trying to map it on to (alphabetically). Mind you I
have never used stored procedures, but I believe these are the
restrictions.
ms
_______________________________________________
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