Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

setMaxRows vs Limit/rownum/top

1036962Jun 12 2014 — edited Oct 15 2014

The JDBC API doc for setmaxRows says that "If this limit is exceeded, the excess rows are "silently dropped".

Consider a Query fetching 1000 rows and i configured setMaxRows to 10 (i.e.) PreparedStatement.setMaxRows(10) .

Now the data from the database , present in packets travelling to my machine contains 10 rows or 1000 rows ?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 10 2014
Added on Jun 12 2014
2 comments
286 views