[Opensource] Trouble with CLOB field when Writing/Reading data size > 4000

[Jennifer Chen]

Thank you for the information and support from Rick
and Mike:) I am going to try and see where I will end
up...

-Jennifer

> Message: 1
> Date: Wed, 11 Jun 2003 10:40:04 -0700
> To: opensource at jcorporate.com
> From: Michael Rimov <rimovm at centercomp.com>
> Subject: Re: [Opensource] Trouble with CLOB field
> when Writing/Reading
>   data size > 4000
> Reply-To: opensource at jcorporate.com
> 
> At 08:26 AM 6/11/2003 -0700, you wrote:
> >Hi Everyone,
> >
> >I got the following Exception when
> inserting/updating
> >a CLOB field with data size greater than 4000
> >characters. The framework works fine when the data
> >size is smaller.
> >
> >I also tried the LOBSupport class as an alternative
> >that running without the exception but the data did
> >not get into the database and I got other failures
> >that I cannot explain.
> >
> >We are using Expresso framework 503 with Weblogic 7
> >SP2 and Oracle9i. The data type mapping in
> >expresso-config.xml is:
> >
> ><type-mapping>
> >       <java-type>CLOB</java-type>
> >       <db-type>CLOB</db-type>
> ></type-mapping>
> >
> >Any suggestions or solutions are welcome:-)
> 
> Jennifer,
> 
> Since the first round of feedback from users it
> seems like Oracle didn't 
> like the way I first implemented LOBs in Expresso.
> 
> So what I've done is reimplemented a new class that
> takes into account a 
> new attribute in expresso-conifig: jdbc called
> 'nativeBlob'.  [It will also 
> apply to clobs].  But for folks that use drivers
> that actually support the 
> native Clob/Blob JDBC data types, the class can be
> used for that.
> 
> If you're adventurous, you can take a look at:
> 
>
com.jcorporate.expresso.core.dataobjects.jdbc.LobField
> 
> in CVS.  I'm wrapping up ea-1, so you could try it
> that way too.  Either 
> way, it would be a great help if Oracle folks could
> test out the new LOB 
> implementation.
> 
>                                                     
>     -Mike
> 
> 
> 
> --__--__--
> 
> Message: 2
> Date: Wed, 11 Jun 2003 16:42:21 -0400
> From: Rick Goeltz <goeltzrt at ornl.gov>
> To: opensource at jcorporate.com
> Cc: Jennifer Chen <jchenus at yahoo.com>
> Subject: [Opensource] Opensource] Trouble with CLOB
> field when Writing/Reading data size >
>  4000
> Reply-To: opensource at jcorporate.com
> 
> Hi Jennifer:
> 
>  > I got the following Exception when
> inserting/updating
>  > a CLOB field with data size greater than 4000
> 
> I once inserted BLOBs (PDF) into Oracle (V8) using
> straight JDBC.  A 
> procedure specific to Oracle was necessary where the
> record was created 
> with a null BLOB, then the record was fetched and
> the BLOB field updated 
> using a stream.  All according to Oracle
> documentation.  Perhaps you face a 
> similar situation.
> 
> Let me know if you'd like a pointer to additional
> documentation (I don't 
> have it in front of me at the moment).
> 
> Rick


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com