Re: BLOBS : how to remove them totally - Mailing list pgsql-general

From Kris Jurka
Subject Re: BLOBS : how to remove them totally
Date
Msg-id Pine.LNX.4.33.0312200826590.30814-100000@leary.csoft.net
Whole thread Raw
In response to Re: BLOBS : how to remove them totally  (Nilabhra Banerjee <nil_ban@yahoo.co.uk>)
Responses Re: BLOBS : how to remove them totally  (Nilabhra Banerjee <nil_ban@yahoo.co.uk>)
List pgsql-general

On Sat, 20 Dec 2003, [iso-8859-1] Nilabhra Banerjee wrote:

> But unfortunately I could not extract this data to
> frontend thru java... I tried in two ways but got the
> same error...after getting the data in Blob or Large
> Object.
>
> Error in connection == FastPath call returned ERROR:
> invalid large-object descriptor: 0

This is usually a symptom of not being in a transaction.  Large objects
need to be done inside a transaction.  Try adding
connection.setAutoCommit(false) somewhere in your code.

Kris Jurka


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: MySQL Gets Functions in Java - Enlightenment Please
Next
From: Jason Godden
Date:
Subject: Re: MySQL Gets Functions in Java - Enlightenment Please