What is the use of setFetchSize() and setMaxRows() methods of the JDBC Statement Interface?

The setFetchSize(int) method defines the number of rows that will be read from the database when the ResultSet needs more rows. setFetchSize(int) affects how the database returns the ResultSet data.

Whereas, setMaxRows(int) method of the ResultSet specifies how many rows a ResultSet can contain at a time. setMaxRows(int) affects the client side JDBC object.

Daniol Thomas

Published on 22-Mar-2019 10:51:21

• Related Questions & Answers
• What is the use of the method setAutoCommit() in JDBC?
• What is the implicit implementation of the interface and when to use implicit implementation of the interface in C#?
• What is the use of default methods in Java?
• What is the use of import statement in Python?
• What is the use of MySQL IGNORE INSERT statement?
• What is Statement in JDBC?
• What is the use of FLUSH PRIVILEGES statement in MySQL?
• What is the use of in flush() and close() methods of BufferedWriter class in Java?
• What is the difference between the methods setBlob() and setBinaryStream() which is preferable in JDBC?
• What is the difference between execute(), executeQuery() and executeUpdate() methods in JDBC?
• What is the use of "assert" statement in Python?
• What is the use of ‘Using’ statement in C#?
• What is the use of OPTIMIZE TABLE statement in maintaining the MySQL tables?
• What is the use of CHECK TABLE statement in maintaining the MySQL tables?
• What is type3 driver of JDBC what are the advantages and disadvantages of it?