Interested to Buy Any Domain ? << Click Here >> for more details...
i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?
- 8 Answers
- 20997 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / sumit
The question is not pretty clear. However, before retriving the records from the database if you want to make sure you get only 100 records in one hit. U can use the following API after creating the statement object.
Statement.setFetchSize(100);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Does sql allow null values ?
How are jdbc statements used?
What is ODBC and JDBC? How do you connect the Database?
What are different parts of a url?
Differentiate between stored procedure and functions?
Why “no suitable driver” error occurs?
What is jdbc odbc bridge?
How to move the cursor in scrollable resultset ?
What is a merge field?
When does the result for an sql statement return null?
What is jdbc driver in java?
Where is ojdbc14 jar located?
Can we have foreign key reference to a non primary key column ?
What is connection pooling and why it is used?
What is 2 phase commit?
