• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Using a MySQL Sproc via WO
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Using a MySQL Sproc via WO

  • Subject: Using a MySQL Sproc via WO
  • From: email@hidden
  • Date: Tue, 22 May 2007 00:06:32 -0400
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/ TP3000101
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Prev by Date: Re: You backtracked too far? not back button.
  • Next by Date: Re: You backtracked too far? not back button.
  • Previous by thread: Re: You backtracked too far? not back button.
  • Next by thread: HSQLDB EOModeler Plugin
  • Index(es):
    • Date
    • Thread