8.3.22 getMaxRows()

(1) Function

This method acquires the maximum number of rows that can be stored in a ResultSet object created from this Statement object, as int data. Any rows in excess of this value are not stored in the ResultSet object (and without notification).

If the value specified in the setLargeMaxRows method exceeds Integer.MAX_VALUE, use the getLargeMaxRows method instead of the getMaxRows method. If you use the getMaxRows method, it will return 0 if the number of rows exceeds Integer.MAX_VALUE.

To Page Top

(2) Format

public synchronized int getMaxRows() throws SQLException

To Page Top

(3) Arguments

None.

To Page Top

(4) Return value

This method returns the maximum number of rows that can be stored in a ResultSet object created from this Statement object, as int data. The value set in the setMaxRows or setLargeMaxRows method is returned. A value of 0 means that no maximum number of rows has been set.

To Page Top

(5) Exceptions

The JDBC driver throws an SQLException in the following cases:

• The Statement object is closed.

• The Connection object that created the Statement object is closed.

To Page Top