It works.
Thanks.
Jie Liang
-----Original Message-----
From: Oliver Jowett [mailto:oliver@opencloud.com]
Sent: Friday, June 18, 2004 6:39 PM
To: Jie Liang
Cc: Kris Jurka; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Prepare Statement
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