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]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to