How to avoid OOM (Out of memory) error when retrieving all records from huge table?

by

With a little more information I can get a more helpful answer.

If you are using MySQL:

stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
       java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);

from http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html:

java.util.Properties info = new java.util.Properties();
info.put ("user", "scott");
info.put ("password","tiger");
info.put ("defaultRowPrefetch","15");
getConnection ("jdbc:oracle:oci:@",info);

More Related Contents:

  1. How to overcome the Permgen Space Exception Without restarting the Server.., Can any one help me
  2. Error java.lang.OutOfMemoryError: GC overhead limit exceeded
  3. Java – escape string to prevent SQL injection
  4. Hibernate show real SQL [duplicate]
  5. Is it possible to catch out of memory exception in java? [duplicate]
  6. How to get SQL from Hibernate Criteria API (*not* for logging)
  7. Using Hibernate’s ScrollableResults to slowly read 90 million records
  8. How to load a large xlsx file with Apache POI?
  9. Processing large xlsx file
  10. How can you call custom database functions with Hibernate?
  11. Unable to execute dex: GC overhead limit exceeded in Eclipse
  12. Getting output from dbms_output.get_lines using JDBC
  13. Java – Can’t use ResultSet after connection close
  14. Timezones in SQL DATE vs java.sql.Date
  15. SQL prepared statement how to select via multiple possible menu selections?
  16. Is there any good dynamic SQL builder library in Java? [closed]
  17. MyBatis Batch Insert/Update For Oracle
  18. Horrendous performance & large heap footprint of Java 8 constructor reference?
  19. Java – shutting down on Out of Memory Error
  20. How can I detect a SQL table’s existence in Java?
  21. How to prevent SQL Injection with JPA and Hibernate?
  22. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  23. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  24. Having a Column name as Input Parameter of a PreparedStatement
  25. Can I have H2 autocreate a schema in an in-memory database?
  26. JPA 2 CriteriaQuery, using a limit
  27. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  28. Java JDBC connection status
  29. Is MERGE an atomic statement in SQL2008?
  30. OutputStream OutOfMemoryError when sending HTTP

Leave a Comment