Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Andrus Adamchik <andrus(at)objectstyle(dot)org>
- Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
- Date: Mon, 1 Aug 2005 10:12:15 -0500 (EST)
- Message-id: <Pine.BSO.4.56.0508011009570.17912@leary.csoft.net> <text/plain>
On Mon, 1 Aug 2005, Andrus Adamchik wrote: > Just tested it with build 312 and the original problem went away. Now > I am seeing a new problem with null BLOBs only: > > java.sql.SQLException: ERROR: column "blob_col" is of type bytea but > expression is of type oid bytea is not the correct type to use when storing Blobs. You need to use oid as the underlying type, or if you want to use bytea you need to use setBytes or setNull(x, Types.BINARY). Kris Jurka
- References:
- Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
- From: Andrus Adamchik
- Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
- Prev by Date: Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
- Next by Date: Re: Timestamp changes committed to HEAD
- Previous by thread: Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
- Next by thread: some improve JDBC
- Indexes: