RE: Large Objects - Mailing list pgsql-jdbc

i have a different but related question - i OCCASIONALLY get a fastpath
error.  i'd guess that it shows up once in every hundred LO requests.  i've
verified that autocommit is set to false.  the stack trace is shown here:

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)
    at org.postgresql.jdbc2.ResultSet.getBytes(ResultSet.java:580)
    at (the rest is from my code)...

any thoughts?

thanks
chris

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Kovács Péter
Sent: Monday, July 30, 2001 3:12 AM
To: noselasd@frisurf.no; daniel.fisher@vt.edu; Daniel Fisher;
pgsql-jdbc@postgresql.org
Subject: RE: [JDBC] Large Objects


This would be the standard way of inserting Large Objects. But last time I
looked at it, it did not work with the jdbc implementation provided with
pgsql.

-----Original Message-----
From: Nils O. Selåsdal [mailto:noselasd@frisurf.no]
Sent: Friday, July 27, 2001 9:44 PM
To: daniel.fisher@vt.edu; Daniel Fisher; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Large Objects

if you want to insert Large Objects, you need to use one of the setXXXStream

of the statement, not setBytes.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org