Re: Oracle Blob Clob Lob Problem

Hi Josef,

Josef Wagner wrote:
> Hello List,
> 
> I have a problem width loading large data from tables width clob-culumns.
> db: oracle 9.2.0.8
> ojb: 1.0.4
> driver: thin
> 
> When i load 15000 rows, my applikation gets an OutOfMemoryError. I have 
> ensure, that Oracle width clobs is the problem, width HSQLDB, all works 
> fine.
> The data in the clob-culumns are texts width AKTUALLY no more then 100 
> charakters.
> 
> I have checked out the trunk of ojb and I see, that in the platform 
> package are some wrapper-classes for clob und blob?

yep, I reworked the LOB-support a bit and add Blob/Clob java-types 
support (before OJB converts all LOB's to byte[]).


> Unforunatelly, I can't test if this is the solution of my problem, 
> because I get lots of errors when starting my application width a jar 
> from the trunk version.
>

Don't use the trunk it's the alpha OJB 2.x. Please check out the 
OJB_1_0_RELEASE branch it's the stable upcoming OJB 1.0.5 version.


> Can anybody tell me, if the source in the trunk is the solution for such 
> problems I have?

Don't know - give it a try.


> Or is the solution to switch to oralce 10g?

I run the LOB-test against OracleXE 10.2.0.1 and 
classes12_g_10.2.0.2.jar driver.
http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/src/test/org/apache/ojb/broker/lob/LOBTest.java?view=markup
The tests handle CLOB's up to 5000 characters.

> Or should I use OCI instead of THIN driver?
>
Sorry I don't know (not a Oracle expert).

regards,
Armin

> Thanks a lot for your answers.
> 
> regrads
> Josef Wagner
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
> 
>