Skip site navigation (1) Skip section navigation (2)

RE: JDBC and LO - invalid large object descriptor

From: Dnesbitt(at)encryptix(dot)com
To: Andreas(dot)Vogler(at)geneon(dot)de
Cc: Dnesbitt(at)encryptix(dot)com, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: JDBC and LO - invalid large object descriptor
Date: 2000-09-29 02:20:55
Message-ID: (view raw or whole thread)
Lists: pgsql-interfaces

Are you doing the following prior to your executeQuery() method call?


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.


> -----Original Message-----
> From: Andreas Vogler [mailto:Andreas(dot)Vogler(at)geneon(dot)de]
> Sent: Sunday, September 24, 2000 6:29 AM
> To: pgsql-interfaces(at)postgresql(dot)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(
> at org.postgresql.fastpath.Fastpath.fastpath(
> at org.postgresql.fastpath.Fastpath.getInteger(
> at org.postgresql.largeobject.LargeObject.tell(
> at org.postgresql.largeobject.LargeObject.size(
> at org.postgresql.jdbc2.ResultSet.getBytes(
> 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


pgsql-interfaces by date

Next:From: James OrrDate: 2000-09-29 07:17:35
Subject: ODBC with version 7.0.2
Previous:From: Ken KachnowichDate: 2000-09-28 22:07:52
Subject: Re: Newlines in String inserts with JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group