Let me ask it this way:
How can we configure driver so it doesn't fetch all records at one time.
for example 100 records per each fetch, So the application server doesn't get OutOfMemoryException.
Thank you.
>> hi guys,
>>
>> I have a very large table, which I should scan it and generate reports. My code is like this:
>>
>> Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");
>> Connection conn = DriverManager.getConnection("jdbc:monetdb://localhost/online", "monetdb", "monetdb");
>>
>> conn.setAutoCommit(false);
>> conn.setHoldability(ResultSet.HOLD_CURSORS_OVER_COMMIT);
>>
>> Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); >> stmt.setFetchSize(10); >> >> ResultSet rs = stmt.executeQuery("SELECT * FROM denorm"); >> >> while (rs.next()) { >> /* process line */ >> } >> >> conn.commit(); >> >> I do not use much ram inside while loop. I get OutOfMemeryException from JVM. >> So I think the driver ignores HOLD_CURSORS_OVER_COMMIT and fetches all records. Is there any solution?
> HOLD_CURSORS_OVER_COMMIT means it keeps the cursor open, right? So what > else can the driver do but keep them open (including the memory > associated to that)? What would you have expected to happen with this > setting?
