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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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