jdbc with oracle DB - out of memory

Question

I've written a simple code that reads a table from oracle DB.

I try to run in on a very big table and I see that it consumes a huge amount of memory.

I thought that using fetchsize will cause it to optimize memory usage (that what happens when using it on SQLSERVER), but it didn't. tried it with various values - from 10 to 100000.

Can't see how I manage to perform a simple task - export a very big oracle table to a csv file.

I use ojdbc6.jar as a driver.

also I use

connection.setAutoCommit(false);

Any idea?

Show us your Java code. I bet you are storing each row somewhere. It is certainly possible to run an export from a really big table without running out of memory (I'm doing that all the time) — user330315
– user330315, Commented Jun 11, 2013 at 15:26

user1997656 · Accepted Answer · 2013-06-11 16:08:40Z

1

Seems like creating the statement with ResultSet.TYPE_FORWARD_ONLY solved this problem.

answered Jun 11, 2013 at 16:08

user1997656

5321 gold badge8 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jdbc with oracle DB - out of memory

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related