Обсуждение: RE: using java servlets ,large objects with postgresql
Hmmm, normally it's (0) not (-1), and that's because you are accessing the large object outside a transaction. I'm assuming that you are running with AutoCommit set to false? -- 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: Monday, November 06, 2000 5:17 PM To: Peter Mount Cc: postgres-inter Subject: using java servlets ,large objects with postgresql i am trying to retrive my data through Web using java servlets but it seems servlet is not able to get the driver as it gives the error : Fastpath: ERROR: lo_tell: invalid large object descriptor (-1) ie. the servlet is not able to get the oid needed to retrieve the data i get this error only when i am using servlet to retrieve the data, i tried by keeping the postgresql.jar in servlet engine's lib directory also. can anyone help to sort out this problem .it's important. i am using JDK2.0 on solaris2.5 platform ------------------------------------------------------------------- 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 ------------------------------------------------------------------
Yes i am with AutoCommit set to false? On Mon, 6 Nov 2000, Peter Mount wrote: > Hmmm, normally it's (0) not (-1), and that's because you are accessing the > large object outside a transaction. > > I'm assuming that you are running with AutoCommit set to false? > > -- > 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: Monday, November 06, 2000 5:17 PM > To: Peter Mount > Cc: postgres-inter > Subject: using java servlets ,large objects with postgresql > > > > i am trying to retrive my data through Web using java servlets > but it seems servlet is not able to get the driver as it gives > the error : Fastpath: ERROR: lo_tell: invalid large object descriptor > (-1) > > ie. the servlet is not able to get the oid needed to retrieve the data > > i get this error only when i am using servlet to retrieve the data, > i tried by keeping the postgresql.jar in servlet engine's lib directory > also. > > can anyone help to sort out this problem .it's important. > i am using JDK2.0 on solaris2.5 platform > > ------------------------------------------------------------------- > > 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 > ------------------------------------------------------------------ > > > > > > > > >
Ok, I'm about to make a fresh build here, so I'll try to reproduce the problem. 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: Monday, November 06, 2000 10:18 PM To: Peter Mount Cc: postgres-inter Subject: RE: using java servlets ,large objects with postgresql Yes i am with AutoCommit set to false? On Mon, 6 Nov 2000, Peter Mount wrote: > Hmmm, normally it's (0) not (-1), and that's because you are accessing the > large object outside a transaction. > > I'm assuming that you are running with AutoCommit set to false? > > -- > 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: Monday, November 06, 2000 5:17 PM > To: Peter Mount > Cc: postgres-inter > Subject: using java servlets ,large objects with postgresql > > > > i am trying to retrive my data through Web using java servlets > but it seems servlet is not able to get the driver as it gives > the error : Fastpath: ERROR: lo_tell: invalid large object descriptor > (-1) > > ie. the servlet is not able to get the oid needed to retrieve the data > > i get this error only when i am using servlet to retrieve the data, > i tried by keeping the postgresql.jar in servlet engine's lib directory > also. > > can anyone help to sort out this problem .it's important. > i am using JDK2.0 on solaris2.5 platform > > ------------------------------------------------------------------- > > 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 > ------------------------------------------------------------------ > > > > > > > > >