You have to wrap all large object calls within a transaction (this is a
restriction of the backend, not JDBC).
To enable them, you call the Connection.setAutoCommit method, and set it to
false.
ie: Connection mycon = ...;
mycon.setAutoCommit(false);// large object calls here
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council
-----Original Message-----
From: Manika dey [mailto:bithi@plasma.ernet.in]
Sent: Wednesday, November 01, 2000 10:02 PM
To: Peter Mount
Cc: postgres-inter
Subject: using large objects with jdbc
I am using largeobject for storing my datafiles in database
postgresql6.3.2
but when I try to retrieve my data from database to a file.i get the following type of error
Exception caught.
java.sql.SQLException: Fastpath: ERROR: lo_tell: invalid large object
descriptor (0)
java.sql.SQLException: Fastpath: ERROR: lo_tell: invalid large object
descriptor (0)
at postgresql.fastpath.Fastpath.fastpath(Fastpath.java:135) at
postgresql.fastpath.Fastpath.fastpath(Fastpath.java:181) at
postgresql.fastpath.Fastpath.getInteger(Fastpath.java:193) at
postgresql.largeobject.LargeObject.tell(LargeObject.java:206) at
postgresql.largeobject.LargeObject.size(LargeObject.java:221) at dfile.<init>(dfile.java:86) at
dfile.main(dfile.java:128)
how can i get rid of the above mentioned errors.
manika
-------------------------------------------------------------------
From:- | Ms. Manika Dey. |Ph.No:--Engineer-SC (Comp. Tech.) | IPR -- 02712
-69276 I.P.R | EXT 336,315BHAT, GANDHINAGAR | Residence -- 079 -
6619967Gujrat-- 382 428 | FAX --- 69017 ------------------------------------------------------------------