Order of params for stored procedures

[sbagaria]

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]

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?

[[email protected]]

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.

[sbagaria]

Thanks! It's not critical. I had some logic defined for empty strings. I now changed it to an '_'.