RE: using large objects with jdbc

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(at)maidstone(dot)gov(dot)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(at)plasma(dot)ernet(dot)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,315
BHAT, GANDHINAGAR | Residence -- 079 - 6619967
Gujrat -- 382 428 | FAX --- 69017
------------------------------------------------------------------