Re: Statement setNull for Types.CLOB

From: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Statement setNull for Types.CLOB
Date: 2005-06-24 21:18:35
Message-ID: 42BC78AB.6080808@genome.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Fri, 18 Feb 2005, Kris Jurka wrote:
> On Fri, 18 Feb 2005, Matt Magoffin wrote:
>> Hibernate calls setNull() passing
>> the Types.CLOB as the SQL type. The Postgres driver is throwing an
>> exception, however, saying that type is unknown.
>
> I've fixed the setNull call to do something,
> but again CLOB really maps to the oid datatype in pg, not text.

I just encountered the same problem with setObject in
postgresql-8.0-311.jdbc3.jar, btw.

I don't understand the bit about oid, so I guess I will use
Types.VARCHAR unless instructed otherwise.

-Kevin Murphy

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andres Olarte 2005-06-24 23:39:54 Problem with Async (multiple) notifications
Previous Message Csaba Nagy 2005-06-24 16:28:53 Re: Which version of driver to use ?