On Fri, 18 Feb 2005, Matt Magoffin wrote:
> Hello, I'm using PostgreSQL 8 and the 310 build of the 8.0 JDBC3 driver
> with Hibernate. For 'text' columns in my database, I had mapped them to
> the Hibernate "text" type. When attempting to set the value of a text
> column to 'null' via a PreparedStatement Hibernate calls setNull() passing
> the Types.CLOB as the SQL type. The Postgres driver is throwing an
> exception, however, saying that type is unknown.
This problem was just reported for bytea/BLOB here:
The same situation applies, I've fixed the setNull call to do something,
but again CLOB really maps to the oid datatype in pg, not text.
In response to
pgsql-jdbc by date
|Next:||From: bkafka||Date: 2005-02-18 20:12:07|
|Subject: jdbc and windows|
|Previous:||From: Matt Magoffin||Date: 2005-02-18 17:41:17|
|Subject: Statement setNull for Types.CLOB|