memory « Resultset « Java Database Q&A

  1. Java Database Q&A
  2. Resultset
  3. memory




1. Does a ResultSet load all data into memory or only when requested?    stackoverflow.com

I have a .jsp page where I have a GUI table that displays records from an Oracle database. This table allows typical pagination behaviour, such as "FIRST", "NEXT", "PREVIOUS" and "LAST". ...

2. Out of Memory allocLargeObjectOrArray from ResultSet    stackoverflow.com

I'm using JDBC to get a large amount of data. The call completes successfully, but when resultSet.next() is called, I get the following error: 

java.lang.OutOfMemoryError: allocLargeObjectOrArray - Object size: 15414016, Num elements: ...

3. Possible memory leak due to not using StringBuffer?    stackoverflow.com

Can the following code cause a memory leak? Would using a StringBuffer actually improve memory usage? A little background: A coworker has been pushing his theories on memory leaks, and this is ...

4. ResultSet Memory    stackoverflow.com

I have ResultSet of 100k records with each record has 5 cell 2 of them are of int data type and 3 are of Varchar (100) data type my question is how ...

5. JDBC resultset memory not freed up    stackoverflow.com

I realized that the memory used by a ResultSet is not freed up even after its close() method is called. I absolutely need to free the memory used by ResultSet after ...

6. About ResultSet and used memory    coderanch.com

Originally posted by Shailesh Chandra: It means that there is nothing being hold in your JVM's memory Not necessarily. There are cases (such as when using scrollable result sets with Oracle or when executing simultaneous statements) when the JDBC driver will have no choice but to create a client side cursor, i.e. cache the whole result set to memory and/or disk. ...