*
The moose likes JDBC and the fly likes Regd JDBS Statement... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regd JDBS Statement..." Watch "Regd JDBS Statement..." New topic
Author

Regd JDBS Statement...

senthil nathan
Greenhorn

Joined: Jun 14, 2002
Posts: 17
Hi,
I have a query which returns 10,000 rows and it takes lot of time to return.so is there any way in java while calling statement.executeQuery that i can mention get only 60 rows...
Thanks.
Senthil
Pat Wallwork
Ranch Hand

Joined: Sep 23, 2001
Posts: 72
In your SQL statement just say limit 60

this limits the results returned to the first 60 for your query
-Pat
senthil nathan
Greenhorn

Joined: Jun 14, 2002
Posts: 17
I'm working in DB2 database...this is not possible....
Any other suggestion...
Thanks
Senthil
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regd JDBS Statement...
 
Similar Threads
Dynabeans Problems
saving multiple rows
Adding the rows in a JSP
Field definitions when creating a table?
adding image to JTable