Hi, One basic question:
String query = "Select * from table"; ResultSet rs = statement.executeQuery(query); Now, suppose the query returns 10,000 records. Whether the resultset will hold all the 10,000 records in memoy (RAM - stack, heap or cache does not matter)., or whenever a rs.next() is called it gets the next record from the database. If the connection.close() is executed after the query is executed, will rs.next() be able to get next records. Regards, Jeelani =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com