JDBC Connection query row limit

glevin
New Contributor II

Anyone know how to increase the amount of rows returned in a JDBC query? Currently we're receiving 1000 rows per query.

Have tried adding a LIMIT 5000 to the end of the query, but no luck.