From: | Larry White <ljw1001(at)gmail(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: prepared statement call fails |
Date: | 2004-12-05 21:59:15 |
Message-ID: | d15ea14a04120513591b42b74b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
That did the trick. Thanks much.
On Mon, 06 Dec 2004 10:38:36 +1300, Oliver Jowett <oliver(at)opencloud(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2004-12-05 22:53:29 | Re: prepared statement call fails |
Previous Message | Oliver Jowett | 2004-12-05 21:38:36 | Re: prepared statement call fails |