Re: CallableStatements: index starts at 2

You probably should use prepareStatement instead of prepareCall. I had the
same problem. You can search the archives to look for a better explanation
which I don't remmember right now

On 12/14/05, Thomas Frieling <frieling(at)8hertz(dot)de> wrote:
>
> It seems that in Version "8.2dev-500 JDBC 3" CallableStatements are
> implemented differently from older Versions.
> The index to set fields now starts at 2.
>
> This _did_ work:
> CallableStatement cS = con.prepareCall("{ call test(?)}";
> cS.setString( 1, "abc" );
>
> This _now_ works:
> CallableStatement cS = con.prepareCall("{ call test(?)}";
> cS.setString( 2, "abc" );
>
> Thanks,
> Thomas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>