Got good and frustrated before asking. I am trying to use a Stored
Procedure for an insert. I am using the method described in EOModeler
documentation
(http://developer.apple.com/documentation/WebObjects/UsingEOModeler/6Work
ingWithEntities/chapter_6_section_5.html#//apple_ref/doc/uid/%20TP3000101
8-CH206-BABGBCJE).
The procedure is written in MySQL 5.1. From MySQL I can call the
procedure like this, call sp_Tran_Insert(9, 9, 99, 99, 'Nine', 1,
104001, 1, 1); and it works fine. I have installed the current JAR
file for MySQL. I used EOModeler to 'discover' the sproc and set it to
insert using that sproc (tried it manually too). I have the arguments
in order and seemingly properly named (column names defaulted to 001,
002, 003, etc). I think I have the right number of parameters (9 to
match the sproc call used above). What I think appears to be wrong or
short sited because I get this error when I try an insert:
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: InsertTransaction
Could/would anyone please shed some light on what I may be missing or
doing incorrectly? Google doesn't know, maybe you do.
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free
from AOL at AOL.com.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
