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

jdbc, pgsql6.5.1, large objects

From: John David Garza <garza(at)cjas(dot)org>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: jdbc, pgsql6.5.1, large objects
Date: 1999-07-30 01:30:34
Message-ID: Pine.BSF.4.10.9907292129190.46423-100000@localhost (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hey folks,

Let's see, my admin just upgraded postgresql to 6.5.1 and now it looks
like FastPath isn't working. More specifically, after creating and opening
a large object using the LargeObjectManager class, any other access
attempts throws the following:

FastPath call returned ERROR:  lo_write: invalid large obj descriptor (0)
FastPath call returned ERROR:  lo_write: invalid large obj descriptor (0)
        at postgresql.fastpath.Fastpath.fastpath(Fastpath.java:141)
        at postgresql.fastpath.Fastpath.fastpath(Fastpath.java:188)
        at postgresql.largeobject.LargeObject.write(LargeObject.java:173)
        at postgresql.largeobject.LargeObject.write(LargeObject.java:188)
        at uploadImage.main(uploadImage.java:87)

In this case, line 87 in uploadImage is:
...
85      LargeObject pict = lobjm.open(num);
86      while ((s=fblob.read(buf, 0, 256)) > 0) {
87              pict.write(buf, 0, s);}
...

Before upgrading to 6.5.1, this program worked fine. Calls to tell, size,
read all cause the same type of exceptions.

Any help would be appreciated.

Other info: FreeBSD 3.2, jdk1.1.8

Thanks,
John David Garza
garza(at)keyframe(dot)cjas(dot)org



Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-07-30 13:57:43
Subject: Re: [INTERFACES] jdbc, pgsql6.5.1, large objects
Previous:From: Tom LaneDate: 1999-07-30 01:19:22
Subject: Re: [INTERFACES] perl5 Should consumeInput obliterate unretrieved Notifys?

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