memory « result « Java Database Q&A





2. Results are being retained in memory!    coderanch.com

Hi All, I have a (relatively) simple problem for which I'm seeking help for. In my database bean (db_connector) I have a method (supplyTopSix) that queries and returns values from a mysql database (which successfully happens). In another java class, I call this method, by supplying it an SQL string, and the data is returned (again, successfully). From a JSP, I ...

3. Memory issue with Result set    coderanch.com

Hi, I have a issue, where we are running a query which returns around 25,000 records or more at a time. Storing that in results set and reading one by one to out put to PDF document is giving out of memory isssue. Can you guys tell me what is the other alternative we can do in order to avoid out ...

4. Memory consumption is same when using result set and using put these value into map    coderanch.com

In below code Iam using 15 column database table which have 5 lakh entries. we are trying to checkout the memory consumption for ResultSet and for Iteration we are puting it into a map but both are give same memory consumption.Please can any one tell us why this is happening? import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.HashMap; import ...