From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Matt Magoffin <postgresql(dot)org(at)msqr(dot)us> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Statement setNull for Types.CLOB |
Date: | 2005-02-18 20:10:19 |
Message-ID: | Pine.BSO.4.56.0502181507450.24216@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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:
http://archives.postgresql.org/pgsql-jdbc/2005-02/msg00115.php
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.
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | bkafka | 2005-02-18 20:12:07 | jdbc and windows |
Previous Message | Matt Magoffin | 2005-02-18 17:41:17 | Statement setNull for Types.CLOB |