jdbc, pgsql6.5.1, large objects - Mailing list pgsql-interfaces

From John David Garza
Subject jdbc, pgsql6.5.1, large objects
Date
Msg-id Pine.BSF.4.10.9907292129190.46423-100000@localhost
Whole thread Raw
Responses Re: [INTERFACES] jdbc, pgsql6.5.1, large objects
List 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@keyframe.cjas.org




pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] perl5 Should consumeInput obliterate unretrieved Notifys?
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] jdbc, pgsql6.5.1, large objects