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
- 18844 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
How can we store the file in the oracle database?
There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
Where jdbc drivermanager class is used?
What are the different types of JDBC drivers?
How many rowset are available in jdbc?
What is the use of jdbc api?
java based application for hospital management
What is JDBC Statement?
How many types of jdbc drivers are there?
What is the difference between jdbc and odbc?
What do you mean by two phase commits?
How does jdbc driver work?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What are the advantages of using jdbc datasource?
What is use of connection pooling?
