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]