Does a ResultSet load all data into memory or only when requested?

by

The Java ResultSet is a pointer (or cursor) to the results in the database. The ResultSet loads records in blocks from the database. So to answer your question, the data is only fetched when you request it but in blocks.

If you need to control how many rows are fetched at once by the driver, you can use the setFetchSize(int rows) method on the ResultSet. This will allow you to control how big the blocks it retrieves at once.

More Related Contents:

  1. Is it possible to specify the schema when connecting to postgres with JDBC?
  2. How to get all table names from a database?
  3. How to get a value from the last inserted row? [duplicate]
  4. How is driver class located in JDBC4
  5. Setting Network Timeout for JDBC connection
  6. how to get list of Databases “Schema” names of MySql using java JDBC
  7. How to simulate a DB for testing (Java)?
  8. com.mysql.jdbc.PacketTooBigException
  9. how to copy data from file to PostgreSQL using JDBC?
  10. How do I unit test jdbc code in java? [closed]
  11. Java PreparedStatement UTF-8 character problem
  12. How to get the insert ID in JDBC?
  13. To prevent a memory leak, the JDBC Driver has been forcibly unregistered
  14. Is java.sql.Timestamp timezone specific?
  15. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  16. Java ResultSet how to check if there are any results
  17. JDBC connection failed, error: TCP/IP connection to host failed
  18. How can I get the SQL of a PreparedStatement?
  19. Is java.sql.Connection thread safe?
  20. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  21. How does Java’s PreparedStatement work?
  22. Create a jTDS connection string
  23. Should I use java.util.Date or switch to java.time.LocalDate
  24. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  25. Display special characters using System.out.println
  26. java error (No suitable driver found)
  27. Cannot use a LIKE query in a JDBC PreparedStatement?
  28. How can I abort a running JDBC transaction?
  29. How to Correctly Close Resources
  30. Postgres UUID JDBC not working

Leave a Comment