Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped.

This method should be used when the row limit may exceed Integer.MAX_VALUE.

The default implementation will throw UnsupportedOperationException

Parameters:

max the new max rows limit; zero means there is no limit

Exceptions:

SQLException if a database access error occurs, this method is called on a closed Statement or the condition max >= 0 is not satisfied