pst.setNull(2, Types.BLOB)

Hello.

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);

Sql to reproduce the problem:
Connection conn = ...
PreparedStatement st = conn.prepareStatement("insert into
blobtest (a,b) values (?,?)");
st.setInt(1, 5);
st.setNull(2, Types.BLOB);
st.execute();
conn.commit();

Stacktrace:
org.postgresql.util.PSQLException: Unknown Types value.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setNull(AbstractJdbc2Stateme
nt.java:1003)
at
org.postgresql.jdbc3.AbstractJdbc3Statement.setNull(AbstractJdbc3Stateme
nt.java:1445)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPr
eparedStatement.java:104)

Looks like AbstractJdbc2Statement are handling BINARY,VARBINARY and
LONGVARBINARY, but not BLOB. Is this a bug or should I not use
Types.BLOB?

Regards,
- Tore.

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