Re: BLOBS : how to remove them totally

From: Kris Jurka <books(at)ejurka(dot)com>
To: Nilabhra Banerjee <nil_ban(at)yahoo(dot)co(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bernd Helmle <mailings(at)oopsware(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: BLOBS : how to remove them totally
Date: 2003-12-20 13:28:42
Message-ID: Pine.LNX.4.33.0312200826590.30814-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Godden 2003-12-20 13:41:03 Re: MySQL Gets Functions in Java - Enlightenment Please
Previous Message Shridhar Daithankar 2003-12-20 13:20:16 Re: MySQL Gets Functions in Java - Enlightenment Please