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

From Oliver Jowett
Subject Re: prepared statement call fails
Date
Msg-id 41B37FDC.1010101@opencloud.com
Whole thread Raw
In response to prepared statement call fails  (Larry White <ljw1001@gmail.com>)
Responses Re: prepared statement call fails  (Larry White <ljw1001@gmail.com>)
List pgsql-jdbc
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: Larry White
Date:
Subject: Re: prepared statement call fails