Hi all, Michael contributed a patch that works around the 4k limit. Unfortunately it is not only a modification of the existing PlatformOracleImpl but has some deeper impact on the codebase. So I did not apply his patch one to one to the codebase. I planned to have a complete walkthrough of his solution in december. But as many other things it got delayed...
Michael, maybe this is a good timing for a relaunch of your solution. Please repost it so that more people get an impression! Thanks for your patience, Thomas > -----Ursprüngliche Nachricht----- > Von: Michael Mogley [mailto:[EMAIL PROTECTED]] > Gesendet: Mittwoch, 29. Januar 2003 02:20 > An: OJB Users List > Betreff: Re: CLOBs vs. Oracle! > > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]