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

Updated on 30-Jul-2019 22:30:25

• 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 import statement in Python?
• What is the use of MySQL IGNORE INSERT statement?
• What is the use of default methods in Java?
• What is Statement in JDBC?
• What is the use of FLUSH PRIVILEGES statement in MySQL?
• What is the use of tail() methods in Pandas series?
• What is the use of head () methods in Pandas series?
• What is the use of abs() methods in pandas series?
• 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 in flush() and close() methods of BufferedWriter class in Java?
• What is the use of "assert" statement in Python?
• What is the use of ‘Using’ statement in C#?