Re: Prepare Statement - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Prepare Statement
Date
Msg-id 40D39942.4010100@opencloud.com
Whole thread Raw
In response to Re: Prepare Statement  ("Jie Liang" <jie@stbernard.com>)
List pgsql-jdbc
Jie Liang wrote:
> Nope, it will get same error msg:
> Myfunction(text) does net exist

Hm, indeed. I just looked at the code and the plain setObject() path
seems slightly broken: it always passes PG_TEXT, not the PGobject's type.

However, the setObject variant that takes a target SQL type seems ok.
Try this:

>    stmt.setObject(1, obj, Types.OTHER);

-O

pgsql-jdbc by date:

Previous
From: "Jie Liang"
Date:
Subject: Re: Prepare Statement
Next
From: "Jie Liang"
Date:
Subject: Re: Prepare Statement