Re: Oracle Blob Clob Lob Problem

Hi Josef,

Did you try inserting this large data outside of OJB using the driver that you are using inside of OJB (Or connection pool). I saw several issues with Oracle's drivers (I forget whether they are thin or OCI drivers). My guess is it's a driver issue than OJB issue.

-Vamsi

----- Original Message ----
From: Josef Wagner <[email protected]>
To: OJB Users List <[email protected]>
Sent: Wednesday, February 7, 2007 10:44:16 AM
Subject: Oracle Blob Clob Lob Problem


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?
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.

Can anybody tell me, if the source in the trunk is the solution for such 
problems I have?
Or is the solution to switch to oralce 10g?
Or should I use OCI instead of THIN driver?

Thanks a lot for your answers.

regrads
Josef Wagner

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]