Re: prepared statement call fails - Mailing list pgsql-jdbc

From Larry White
Subject Re: prepared statement call fails
Date
Msg-id d15ea14a04120513591b42b74b@mail.gmail.com
Whole thread Raw
In response to Re: prepared statement call fails  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
That did the trick.  Thanks much.


On Mon, 06 Dec 2004 10:38:36 +1300, Oliver Jowett <oliver@opencloud.com> wrote:
> Larry White wrote:
>
> >               proc = connection.prepareCall("{ ? =  call add_country( ? ? ? ? ) }");
>
> You are missing commas between your ? parameter placeholders.
>
> Try:
>
>    proc = connection.prepareCall("{ ? =  call add_country(?,?,?,?) }");
>
> Otherwise your code looks OK.
>
> It may be useful to turn on statement logging on the server side if you
> have more problems -- the JDBC driver is transforming your query and it
> can be useful to see exactly what's getting sent to the server.
>
> -O
>

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: prepared statement call fails
Next
From: Thomas Hallgren
Date:
Subject: Re: prepared statement call fails