Re: Prepare Statement

It works.
Thanks.

Jie Liang

-----Original Message-----
From: Oliver Jowett [mailto:oliver(at)opencloud(dot)com]
Sent: Friday, June 18, 2004 6:39 PM
To: Jie Liang
Cc: Kris Jurka; pgsql-jdbc(at)postgresql(dot)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