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@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 ------------------------------------------------------------------