Re: Statement setNull for Types.CLOB - Mailing list pgsql-jdbc

From Kevin Murphy
Subject Re: Statement setNull for Types.CLOB
Date
Msg-id 42BC78AB.6080808@genome.chop.edu
Whole thread Raw
In response to Statement setNull for Types.CLOB  ("Matt Magoffin" <postgresql.org@msqr.us>)
List 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


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Which version of driver to use ?
Next
From: Andres Olarte
Date:
Subject: Problem with Async (multiple) notifications