Re: Prepare Statement

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Prepare Statement
Date: 2004-06-19 01:39:14
Message-ID: 40D39942.4010100@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jie Liang 2004-06-19 02:14:48 Re: Prepare Statement
Previous Message Jie Liang 2004-06-19 01:30:45 Re: Prepare Statement