Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group