Thursday, January 24, 2008 02:30 AM
When I execute
ResultSet resultset = statement.executeQuery("xxx");
is the entire resultset brought into java memory(heap) or it will only be fetched based on the fetchSize set in Oracle? Does this behaviour depend on the driver chosen. Please explain, what happens if i have retrieved 1 lakh records.