Mon Nov 29, 2021 6:01 am
Login Register Lost Password? Contact Us


Order of params for stored procedures

Topics around the use of the JDBC driver for HPCC Systems

Tue Apr 16, 2013 5:13 pm Change Time Zone

I am trying to use the JDBC driver for using published queries. Everything works fine on queries with one or two params. But when there are multiple params, I can't seem to get back any results.

Do you have examples on how best to handle multiple parameters for a query of different types?
sbagaria
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 92
Joined: Thu Jul 05, 2012 9:23 pm

Tue Apr 16, 2013 5:25 pm Change Time Zone

OK. Got some hints. I have to skip the quote characters. They are considered a part of the string. The order is what appears in the wsECL interface or the columns information for the procedure.

Now the only remaining question is how do I either skip a parameter so that the default value is taken from the ECL code or input an empty string as the param?
sbagaria
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 92
Joined: Thu Jul 05, 2012 9:23 pm

Mon Apr 22, 2013 6:03 pm Change Time Zone

The driver doesn't currently allow mismatching stored procedure signatures (it rejects the request if the number of in params don't match.)

Let me know if this is an issue for you, we can discuss a change request if it makes sense. Thanks, Rodrigo.
rodrigo.pastrana@lexisnexis.com
 
Posts: 22
Joined: Fri Oct 07, 2011 2:24 pm

Mon Apr 22, 2013 6:04 pm Change Time Zone

Thanks! It's not critical. I had some logic defined for empty strings. I now changed it to an '_'.
sbagaria
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 92
Joined: Thu Jul 05, 2012 9:23 pm


Return to Java Tools

Who is online

Users browsing this forum: No registered users and 1 guest

cron