maxrows

Properties:

Where it can be set: In the URL or in a Properties Object
Possible Values: Integer (representing the number of rows) or 0 (all rows – no limit)
Default: 0 (all rows – no limit)

Comments:

This property and its default value match the JDBC standard. You can reset this limit within the scope of a statement in your code. Each individual statement uses the initial limit specified by the value of this property.