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?
Thanks
Mark
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
