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

Re: pst.setNull(2, Types.BLOB)

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tore Halset <halset(at)pvv(dot)ntnu(dot)no>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: pst.setNull(2, Types.BLOB)
Date: 2005-02-17 03:21:06
Message-ID: Pine.BSO.4.56.0502162219090.25741@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Wed, 16 Feb 2005, Tore Halset wrote:

> I have just tried to upgrade my jdbc driver, but have a problem with  
> setNull for blobs. I am using postgresql-8.0-310.jdbc3.jar with  
> commons-dbcp-1.2.1.jar and postgresql-8.0.1.
> 
> The test table:
> create table blobtest (a int primary key, b bytea);
> 
>              st.setNull(2, Types.BLOB);

This case did not work, and I've committed changes to cvs to make it work, 
but not for the bytea case.  BLOB implies using large objects, so it will 
set type the null value as oid, not bytea.  You should use one of the 
binary types for bytea.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-02-17 19:38:22
Subject: Re: JDBC driver
Previous:From: Kris JurkaDate: 2005-02-17 03:18:32
Subject: Re: jdbc security

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