Postgres Pro
Downloads
Home   >   mailing lists

Re: can't write a BLOB, 7.1.2 - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: can't write a BLOB, 7.1.2
Date
Msg-id 27871.994876061@sss.pgh.pa.us
Whole thread Raw
In response to can't write a BLOB, 7.1.2  ("Dejan Vucinic" <hotdejan@hotmail.com>)
List pgsql-jdbc
Tree view 
"Dejan Vucinic" <hotdejan@hotmail.com> writes:
> I'm trying to create a BLOB with the 7.1.2 JDBC driver and both
> setBytes() and setBinaryStream() fail with this message:
>   FastPath call returned ERROR:  lo_write: invalid large obj descriptor (0)

Probably you are not wrapping the operation into a transaction
(BEGIN/COMMIT).  Large object descriptors are only good to the end of
the current transaction.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: "Dejan Vucinic"
Date:
Subject: [PATCH] setTimestamp(int, Timestamp) fails on null timestamp
Next
From: "Dave Cramer"
Date:
Subject: RE: [PATCH] setTimestamp(int, Timestamp) fails on null timestamp