Skip site navigation (1) Skip section navigation (2)

Re: Statement setNull for Types.CLOB

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 (view raw or flat)
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

In response to

pgsql-jdbc by date

Next:From: bkafkaDate: 2005-02-18 20:12:07
Subject: jdbc and windows
Previous:From: Matt MagoffinDate: 2005-02-18 17:41:17
Subject: Statement setNull for Types.CLOB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group