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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kovács Péter
Sent: Monday, July 30, 2001 3:12 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Daniel Fisher;
[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 9:44 PM
To: [EMAIL PROTECTED]; Daniel Fisher; [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
