Hi,
I want to know why the Resultset.close() didnot release the heap? is it a
bug or there is a workaround.
I have a 32 MB db and when i wrote this i lost 5 MB that didnt free:
///////////////////////////////
rs = stmt.executeQuery("select * from table");
while(rs.next());
con.clearWarnings();
stmt.clearWarnings();
rs.clearWarnings();
rs.close();
con.commit();
stmt.close();
con.close();
//////////////////////////////
i dont know why
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/