Received: from pixinguinha.radix.com.br (pixinguinha.radix.com.br
	[200.133.34.111] (may be forged))
	by hub.org (8.10.1/8.10.1) with SMTP id e92Iqnb44965
	for <pgsql-interfaces@postgresql.org>;
	Mon, 2 Oct 2000 14:52:50 -0400 (EDT)
Received: (qmail 17034 invoked from network); 2 Oct 2000 18:40:19 -0000
Received: from unknown (HELO radix.com.br) (200.249.104.8)
	by 200.133.34.21 with SMTP; 2 Oct 2000 18:40:19 -0000
Message-ID: <39D8DAB9.35A9F517@radix.com.br>
Date: Mon, 02 Oct 2000 15:58:01 -0300
From: Nelson Ferreira Jr <nelson@radix.com.br>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Dnesbitt@encryptix.com, pgsql-interfaces@postgresql.org
Subject: Re: JDBC and LO - invalid large object descriptor
References: <19016070071ED411B61300508BAC4B75041A61@exch1etix.encryptix.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200010/5

          I also got these errors even doing
                conn.setAutoCommit(false);
         in a high-load enviroment.
         The solution is that you have to do a
               conn.commit();
         after acessing the BLOB (even if you're only reading data)


                                                              []'s


Dnesbitt@encryptix.com wrote:

> Andreas,
>
> Are you doing the following prior to your executeQuery() method call?
>
>             conn.setAutoCommit(false);
>
> If not, then I think that may be your problem.  It may seem weird to do a
> query in a transaction, but that is how it works.
>
> Regards,
> //Dave
>
> > -----Original Message-----
> > From: Andreas Vogler [mailto:Andreas.Vogler@geneon.de]
> > Sent: Sunday, September 24, 2000 6:29 AM
> > To: pgsql-interfaces@postgresql.org
> > Subject: [INTERFACES] JDBC and LO - invalid large object descriptor
> >
> >
> > Hi,
> >
> > I have got a problem with reading large objects from Postgres
> > through JDBC
> > (both 7.0.2):
> > a call to resultset.getBytes(...) results in:
> >
> > FastPath call returned ERROR:  lo_tell: invalid large object
> > descriptor (0)
> > at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:141)
> > at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:191)
> > at org.postgresql.fastpath.Fastpath.getInteger(Fastpath.java:203)
> > at org.postgresql.largeobject.LargeObject.tell(LargeObject.java:232)
> > at org.postgresql.largeobject.LargeObject.size(LargeObject.java:247)
> > at org.postgresql.jdbc2.ResultSet.getBytes(ResultSet.java:370)
> >
> > using "select lo_export(...)" is no problem, so I suppose the
> > data is stored
> > correctly within the DB.
> > Any idea where the 0 is comming from or what the problem could be?
> >
> > Bye
> >       Andreas
> >