RE: Large Objects

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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Kovács Péter
Sent: Monday, July 30, 2001 3:12 AM
To: noselasd(at)frisurf(dot)no; daniel(dot)fisher(at)vt(dot)edu; Daniel Fisher;
pgsql-jdbc(at)postgresql(dot)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(at)frisurf(dot)no]
Sent: Friday, July 27, 2001 9:44 PM
To: daniel(dot)fisher(at)vt(dot)edu; Daniel Fisher; pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org