• 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
Re: Stored procedure problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Stored procedure problem


  • Subject: Re: Stored procedure problem
  • From: Chuck Hill <email@hidden>
  • Date: Mon, 28 Dec 2009 09:54:41 -0800


On Dec 28, 2009, at 9:43 AM, Mark Woollard wrote:

Am trying to get rows from a stored procedure, first time I've tried to do this with WO. I have a stored procedure in the database (mysql) find_zips which takes a single argument of a zip code as a varchar. I've created a stored procedure in the Entity Model FindZIps with a single argument to match the procedure. I'm using it as follows:

NSArray<NSDictionary> results;
NSDictionary<String,String> args = new NSDictionary<String,String>(searchString,"search");
results = EOUtilities.rawRowsForStoredProcedureNamed(ec,"FindZips",args);


I get the following error from the rawRowsForStoredProcedureNamed method:

EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn $MySQLExpression: \"{ call find_zips (?)}\" withBindings: 1:\"04103\"(search)>:\n Next exception:SQL State:42000 -- error code: 1305 -- msg: FUNCTION find_zips does not exist

It seems to me the call being generated is correct and since the procedure exists (and is being used by non-WO code without problem) am a bit stuck. I'm probably missing something obvious as new to WO so anyone got any ideas?

Is it created in the same schema/catalog as the rest of entities? Does the user you are connecting as have permissions for this procedure?



Chuck

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








_______________________________________________
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


  • Follow-Ups:
    • Re: Stored procedure problem
      • From: Mark Woollard <email@hidden>
References: 
 >Stored procedure problem (From: Mark Woollard <email@hidden>)

  • Prev by Date: Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
  • Next by Date: Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
  • Previous by thread: Re: Stored procedure problem
  • Next by thread: Re: Stored procedure problem
  • Index(es):
    • Date
    • Thread