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