RE: using large objects with jdbc

From: Peter Mount <petermount(at)maidstone(dot)gov(dot)uk>
To: "'Manika dey'" <bithi(at)plasma(dot)ernet(dot)in>, Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
Cc: postgres-inter <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: using large objects with jdbc
Date: 2000-11-02 10:25:01
Message-ID: 1B3D5E532D18D311861A00600865478CF1B4C1@exchange1.nt.maidstone.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Turn off auto commit using:

Connection mycon;
mycon.setAutoCommit(false);

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: 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,315
BHAT, GANDHINAGAR | Residence -- 079 - 6619967
Gujrat -- 382 428 | FAX --- 69017
------------------------------------------------------------------


Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-11-02 10:25:51 RE: JDBC - setAsciiStream - how to support?
Previous Message Peter Mount 2000-11-02 10:24:20 RE: using large objects with jdbc