Rajeev, A limitation indeed.
Thomas, any thoughts? :) Michael ----- Original Message ----- From: "Rajeev Kaul" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 3:15 PM Subject: Re: CLOBs vs. Oracle! > Matthew, > > I guess, in that case we have a limitation with the Oracle thin driver and > CLOBs/BLOBs. Both Oralce 8i and Oracle 9i don't directly support > updating/inserting Blob or Clob data using the Thin driver (that is, the > pure Java driver) if the data is bigger then 4000 bytes. > > > Rajeev > ----- Original Message ----- > From: "Matthew Baird" <[EMAIL PROTECTED]> > To: "OJB Users List" <[EMAIL PROTECTED]> > Sent: Tuesday, January 28, 2003 2:05 PM > Subject: RE: CLOBs vs. Oracle! > > > > short answer is "yes". > > > > Oracle recommends you use the thin driver in java based application > servers (ejb, jsp, whatever). I believe there are potential concurrency > problems, or concurrency performance issues. > > > > Cheers, > > Matthew > > > > -----Original Message----- > > From: Rajeev Kaul [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 28, 2003 1:59 PM > > To: OJB Users List; Michael Mogley > > Subject: Re: CLOBs vs. Oracle! > > > > > > Michael, > > > > Okay. May be my solution only works for the Oracle "OCI" driver - not the > > Oracle "thin" driver. Is there any problem in using the OCI driver in > > webapps? > > > > Rajeev > > ----- Original Message ----- > > From: "Michael Mogley" <[EMAIL PROTECTED]> > > To: "OJB Users List" <[EMAIL PROTECTED]> > > Sent: Tuesday, January 28, 2003 1:40 PM > > Subject: Re: CLOBs vs. Oracle! > > > > > > > Rajeev, > > > > > > I believe this problem occurs with the thin driver, which represents the > > > typical scenario for a web app. > > > > > > Michael > > > > > > ----- Original Message ----- > > > From: "Rajeev Kaul" <[EMAIL PROTECTED]> > > > To: "OJB Users List" <[EMAIL PROTECTED]>; "Michael Mogley" > > > <[EMAIL PROTECTED]> > > > Sent: Tuesday, January 28, 2003 12:05 PM > > > Subject: Re: CLOBs vs. Oracle! > > > > > > > > > > Michael, > > > > > > > > Yes, I have run the BlobTest (OJB supplied test case) with size set to > > > > 10000, and I have had no problem. I know some other users also have > > > > reported problems with size > 4000. However, I cannot seem to > recreate > > > the > > > > problem on my end. I do not know if it has anything to do with the > > > > PersistentBroker API, driver(OCI8) and Oracle version (8.1.7) I am > > using. > > > > > > > > Rajeev > > > > ----- Original Message ----- > > > > From: "Michael Mogley" <[EMAIL PROTECTED]> > > > > To: "OJB Users List" <[EMAIL PROTECTED]> > > > > Sent: Tuesday, January 28, 2003 10:56 AM > > > > Subject: Re: CLOBs vs. Oracle! > > > > > > > > > > > > > Rajeev, > > > > > > > > > > Have you tested this fix for strings greater than 4K? I've tried > the > > > > > setCharacterStream approach in the past and have had problems with > it. > > > > > > > > > > Michael > > > > > > > > > > ----- Original Message ----- > > > > > From: "Rajeev Kaul" <[EMAIL PROTECTED]> > > > > > To: "OJB Users List" <[EMAIL PROTECTED]>; "sclark" > > > > > <[EMAIL PROTECTED]> > > > > > Sent: Tuesday, January 28, 2003 10:24 AM > > > > > Subject: Re: CLOBs vs. Oracle! > > > > > > > > > > > > > > > > CLOBs do not work out of the box with Oracle and 0.9.8. However, > I > > > have > > > > > > managed to make them work for me with Oracle 8.1.7 and OJB 0.9.8. > > with > > > > the > > > > > > attached modifications. I have also included my repository > settings > > > if > > > > > they > > > > > > are of any help. > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "sclark" <[EMAIL PROTECTED]> > > > > > > To: <[EMAIL PROTECTED]> > > > > > > Sent: Monday, January 27, 2003 4:33 PM > > > > > > Subject: CLOBs vs. Oracle! > > > > > > > > > > > > > > > > > > > I'm having trouble getting CLOBs to work with Oracle (9.0.1, OJB > > > > 0.9.8), > > > > > > and in > > > > > > > truth I'm not clear whether they are expected to. I have tried > > with > > > > and > > > > > > without > > > > > > > various pieces of Rajeev's patch from last November > > > > > > > > > > (http://archives.apache.org/eyebrowse/ReadMsg?listId=107&msgNo=3610), > > > > > > which has > > > > > > > not been committed to CVS, and I get a variety of exceptions > > during > > > > > read, > > > > > > write, > > > > > > > or both. > > > > > > > > > > > > > > Can somebody confirm whether CLOBs work out of the box with > Oracle > > > and > > > > > > 0.9.8? > > > > > > > > > > > > > > thanks, > > > > > > > -steve > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > To unsubscribe, e-mail: > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > For additional commands, e-mail: > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------------- > > > > -- > > > > > ---- > > > > > > > > > > > > > > > > -- > > > > > > To unsubscribe, e-mail: > > > > <mailto:[EMAIL PROTECTED]> > > > > > > For additional commands, e-mail: > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > -- > > > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > -- > > > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
