Skip site navigation (1) Skip section navigation (2)

Re: CallableStatements: index starts at 2

From: Andres Olarte <olarte(dot)andres(at)gmail(dot)com>
To: Thomas Frieling <frieling(at)8hertz(dot)de>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: CallableStatements: index starts at 2
Date: 2005-12-14 16:38:24
Message-ID: 3fccaa690512140838o464dd369y4194a05c4f28d553@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2005-12-14 17:41:58
Subject: Re: CallableStatements: index starts at 2
Previous:From: Achilleus MantziosDate: 2005-12-14 13:43:37
Subject: Re: Group Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group