pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: using large objects with jdbc
14+ messages / 5 participants
[nested] [flat]
* RE: using large objects with jdbc
@ 2000-08-25 06:33 Peter Mount <petermount@it.maidstone.gov.uk>
2000-08-25 21:19 ` RE: using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
2000-09-05 16:23 ` RE: using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
2000-11-01 22:01 ` using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
2000-11-02 17:36 ` RE: using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
2000-11-02 18:02 ` RE: using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
0 siblings, 5 replies; 14+ messages in thread
From: Peter Mount @ 2000-08-25 06:33 UTC (permalink / raw)
To: 'Manika dey' <bithi@plasma.ernet.in>; pgsql-interfaces
Ok, first you run it from the src/interface/jdbc directory, not from within
example.
Then you run it using:
java example.blobtest jdbc:postgresql:mydb user passwd
Where mydb is your database, user & passwd are obvious.
To get some extra debug info, add d to the end.
Also, make sure that the current directory is in the CLASSPATH.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@it.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: Friday, August 25, 2000 3:28 PM
To: postgres-inter
Subject: [INTERFACES] using large objects with jdbc
Hi,
i am having postgresql 6.3.2 with jdk1.1.4 on solaris platform
i tried to run the example of blobtest.java in directory
postgres/postgresql-6.3.2/src/interfaces/jdbc/example
i get error of : --
Can't find class blobtest
i have compiled it successfully
can anyone help me out of it
thanks
manika
-------------------------------------------------------------------
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 |
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-08-25 21:19 ` Manika dey <bithi@plasma.ernet.in>
4 siblings, 0 replies; 14+ messages in thread
From: Manika dey @ 2000-08-25 21:19 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
Hi,
thanks
it worked from postgres directory above example dir ie:
from postgres/postgresql-6.3.2/src/interfaces/jdbc
but i am having the following problem
* if i compile if it form my home dir by copying it in anyother
by commenting the sentence package example
i get error of Class LargeObjectManager not found in type declaration.
int oid =
lobj.create(LargeObjectManager.READ|LargeObjectManager.WRITE);
* it moves only those files to database which in the dir of postgres
and not the ones which are in my home dir
how can i solve this problem
-------------------------------------------------------------------
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 |
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-09-05 16:23 ` Manika dey <bithi@plasma.ernet.in>
2000-09-05 09:49 ` Re: using large objects with jdbc Peter Mount <peter@retep.org.uk>
4 siblings, 1 reply; 14+ messages in thread
From: Manika dey @ 2000-09-05 16:23 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
Hi,
can storing and retrieving of data from postgresql-6.3.2 be
done distributedly using corba (e.g visibroker for java )
if so can anyone give a sample of it
thank you
manika
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
2000-09-05 16:23 ` RE: using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
@ 2000-09-05 09:49 ` Peter Mount <peter@retep.org.uk>
0 siblings, 0 replies; 14+ messages in thread
From: Peter Mount @ 2000-09-05 09:49 UTC (permalink / raw)
To: Manika dey <bithi@plasma.ernet.in>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
[Reply from retep.org.uk as I can't seem to post from work anymore, incase
you see two replies to this.]...
In the source (src/interfaces/jdbc/example/corba) there's an example of
using Postgresql & JDBC using corba. It only works for JDK1.2 and later, and
was included in the source since 6.5.1. In theory the example should work
with the 6.3.x driver as it uses only standard API calls.
Peter
--
Peter T Mount peter@retep.org.uk, me@petermount.com
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF Generator: http://www.retep.org.uk/pdf/
----- Original Message -----
From: "Manika dey" <bithi@plasma.ernet.in>
To: "Peter Mount" <petermount@it.maidstone.gov.uk>
Cc: "postgres-inter" <pgsql-interfaces@postgresql.org>
Sent: Tuesday, September 05, 2000 5:23 PM
Subject: RE: [INTERFACES] using large objects with jdbc
>
> Hi,
> can storing and retrieving of data from postgresql-6.3.2 be
> done distributedly using corba (e.g visibroker for java )
>
> if so can anyone give a sample of it
>
> thank you
> manika
>
>
>
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-11-01 22:01 ` Manika dey <bithi@plasma.ernet.in>
2000-11-01 14:51 ` Re: using large objects with jdbc Thomas Lockhart <lockhart@alumni.caltech.edu>
4 siblings, 1 reply; 14+ messages in thread
From: Manika dey @ 2000-11-01 22:01 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
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,315
BHAT, GANDHINAGAR | Residence -- 079 - 6619967
Gujrat -- 382 428 | FAX --- 69017
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
2000-11-01 22:01 ` using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
@ 2000-11-01 14:51 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 14+ messages in thread
From: Thomas Lockhart @ 2000-11-01 14:51 UTC (permalink / raw)
To: Manika dey <bithi@plasma.ernet.in>; +Cc: Peter Mount <petermount@it.maidstone.gov.uk>; pgsql-interfaces
> how can i get rid of the above mentioned errors.
PostgreSQL 6.3.2 is *very* old, and a lot has been improved since that
release (including many improvements and fixes in the large objects).
Upgrading to 7.0.2 would be a very good idea, and most likely will make
the LO errors go away.
- Thomas
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-11-02 17:36 ` Manika dey <bithi@plasma.ernet.in>
4 siblings, 0 replies; 14+ messages in thread
From: Manika dey @ 2000-11-02 17:36 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
when i try to use jdbc interface of postgres from my directory it gives
me the errors mentioned below , but the example programs in postgres
directory compiles and runs prefectly (when login as postgres)
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/largeobject/LargeObjectManager.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
Connection.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgre
sql/largeobject/LargeObject.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc
/postgresql/fastpath/Fastpath.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/
Bpostgresql/ResultSet.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/fastpath/FastpathArg.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/PG_Stream.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
Driver.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/util/UnixCrypt.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
Statement.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
PreparedStatement.class
-------------------------------------------------------------------
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
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-11-02 18:02 ` Manika dey <bithi@plasma.ernet.in>
4 siblings, 0 replies; 14+ messages in thread
From: Manika dey @ 2000-11-02 18:02 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
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
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: RE: using large objects with jdbc
@ 2000-08-25 14:24 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 14+ messages in thread
From: Peter Mount @ 2000-08-25 14:24 UTC (permalink / raw)
To: 'Manika dey' <bithi@plasma.ernet.in>; Peter Mount <petermount@maidstone.gov.uk>; +Cc: pgsql-interfaces
Are you importing the postgresql.largeobject package?
ie
import postgresql.largeobject.*;
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: Friday, August 25, 2000 10:19 PM
To: Peter Mount
Cc: postgres-inter
Subject: [INTERFACES] RE: using large objects with jdbc
Hi,
thanks
it worked from postgres directory above example dir ie:
from postgres/postgresql-6.3.2/src/interfaces/jdbc
but i am having the following problem
* if i compile if it form my home dir by copying it in anyother
by commenting the sentence package example
i get error of Class LargeObjectManager not found in type declaration.
int oid =
lobj.create(LargeObjectManager.READ|LargeObjectManager.WRITE);
* it moves only those files to database which in the dir of postgres
and not the ones which are in my home dir
how can i solve this problem
-------------------------------------------------------------------
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 |
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* using large objects with jdbc
@ 2000-08-25 14:28 Manika dey <bithi@plasma.ernet.in>
0 siblings, 0 replies; 14+ messages in thread
From: Manika dey @ 2000-08-25 14:28 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
i am having postgresql 6.3.2 with jdk1.1.4 on solaris platform
i tried to run the example of blobtest.java in directory
postgres/postgresql-6.3.2/src/interfaces/jdbc/example
i get error of : --
Can't find class blobtest
i have compiled it successfully
can anyone help me out of it
thanks
manika
-------------------------------------------------------------------
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 |
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
@ 2000-09-05 06:46 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 14+ messages in thread
From: Peter Mount @ 2000-09-05 06:46 UTC (permalink / raw)
To: 'Manika dey' <bithi@plasma.ernet.in>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
The driver won't be compatible, but if you look at the source to the 6.5.x
series you'll find a directory called example/corba. In there is an example
of using postgresql, jdbc & corba together.
PS: This only works for JDK1.2 and later.
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: Tuesday, September 05, 2000 5:23 PM
To: Peter Mount
Cc: postgres-inter
Subject: RE: [INTERFACES] using large objects with jdbc
Hi,
can storing and retrieving of data from postgresql-6.3.2 be
done distributedly using corba (e.g visibroker for java )
if so can anyone give a sample of it
thank you
manika
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
@ 2000-11-01 11:29 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 14+ messages in thread
From: Peter Mount @ 2000-11-01 11:29 UTC (permalink / raw)
To: 'Manika dey' <bithi@plasma.ernet.in>; +Cc: pgsql-interfaces
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,315
BHAT, GANDHINAGAR | Residence -- 079 - 6619967
Gujrat -- 382 428 | FAX --- 69017
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
@ 2000-11-02 10:24 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 14+ messages in thread
From: Peter Mount @ 2000-11-02 10:24 UTC (permalink / raw)
To: 'Manika dey' <bithi@plasma.ernet.in>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
As JDBC doesn't use any local files, I'd say this is caused by make trying
to rebuild the driver, and is a local file permissions problem. Check that
your user has write access to that part of the source.
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 5:36 PM
To: Peter Mount
Cc: postgres-inter
Subject: RE: [INTERFACES] using large objects with jdbc
when i try to use jdbc interface of postgres from my directory it gives
me the errors mentioned below , but the example programs in postgres
directory compiles and runs prefectly (when login as postgres)
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/large
object/LargeObjectManager.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
Connection.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgre
sql/largeobject/LargeObject.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc
/postgresql/fastpath/Fastpath.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/
Bpostgresql/ResultSet.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/fastp
ath/FastpathArg.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/PG_St
ream.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
Driver.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/util/
UnixCrypt.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
Statement.class
error: Can't write:
/users16/home/postgres/postgresql-6.3.2/src/interfaces/jdbc/postgresql/
PreparedStatement.class
-------------------------------------------------------------------
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
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: using large objects with jdbc
@ 2000-11-02 10:25 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 14+ messages in thread
From: Peter Mount @ 2000-11-02 10:25 UTC (permalink / raw)
To: 'Manika dey' <bithi@plasma.ernet.in>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
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,315
BHAT, GANDHINAGAR | Residence -- 079 - 6619967
Gujrat -- 382 428 | FAX --- 69017
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2000-11-02 18:02 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-25 06:33 RE: using large objects with jdbc Peter Mount <petermount@it.maidstone.gov.uk>
2000-08-25 21:19 ` Manika dey <bithi@plasma.ernet.in>
2000-09-05 16:23 ` Manika dey <bithi@plasma.ernet.in>
2000-09-05 09:49 ` Peter Mount <peter@retep.org.uk>
2000-11-01 22:01 ` Manika dey <bithi@plasma.ernet.in>
2000-11-01 14:51 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-11-02 17:36 ` Manika dey <bithi@plasma.ernet.in>
2000-11-02 18:02 ` Manika dey <bithi@plasma.ernet.in>
2000-08-25 14:24 RE: RE: using large objects with jdbc Peter Mount <petermount@maidstone.gov.uk>
2000-08-25 14:28 using large objects with jdbc Manika dey <bithi@plasma.ernet.in>
2000-09-05 06:46 RE: using large objects with jdbc Peter Mount <petermount@maidstone.gov.uk>
2000-11-01 11:29 RE: using large objects with jdbc Peter Mount <petermount@maidstone.gov.uk>
2000-11-02 10:24 RE: using large objects with jdbc Peter Mount <petermount@maidstone.gov.uk>
2000-11-02 10:25 RE: using large objects with jdbc Peter Mount <petermount@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox