RE: using large objects with jdbc

Turn off auto commit using:
Connection mycon;mycon.setAutoCommit(false);

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: Thursday, November 02, 2000 6:03 PM
To: Peter Mount
Cc: postgres-inter
Subject: RE: [INTERFACES] using large objects with jdbc



Hi,
 in the very prevoius mail i mailed you some error i have  rectified it but i am getting the following error  now 
Opening large object 25121
Opening test destination object
Copying large object to file
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)


it writes fine to database but while reading it gives the above mentioned
error
i will be thankful if somebody can help solve this problem .thanks
-------------------------------------------------------------------

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