MySQL Stored Procedure in EOModeler
MySQL Stored Procedure in EOModeler
- Subject: MySQL Stored Procedure in EOModeler
- From: email@hidden
- Date: Tue, 04 Sep 2007 23:26:03 -0400
Anyone have a hint or answer?
I'm using MySQL 5.x and want to use a stored procedure for insert and it's not working. I followed the Apple Documentation.
I made the sproc in MySQL and tested it thoroughly to ensure it works error free (it does). I "discovered" it with EOModeler and added it to my model. I selected the entity to use it on and set it for the insert. I then made a Direct to WebServices project that does an insert on that entity. I run it and get this error:
Exception:
com.webobjects.foundation.NSForwardException [org.apache.axis.AxisFault] java.lang.IllegalArgumentException: com.webobjects.eoaccess.EOGeneralAdaptorException: Parameter index out of range (1 > number of parameters, which is 0).: Exception trying to invoke operation: transactions
I then made sure that the project is submitting in the same order as the sproc expects (by ordering the fields) and still no luck. The number of parameters (fields) is equal to what the sproc expects.
Anyone have a hint? Is there a way that I can see exactly what WO D2WS is sending?
Thanks much for any help,
--Mat
_______________________________________________
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