Re: [BUGS] [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB

#1

On Mon, 1 Aug 2005, Andrus Adamchik wrote:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB - 08-01-2005 , 10:15 AM