aspose file tools*
The moose likes JDBC and the fly likes How paging by JDBC ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How paging by JDBC ?" Watch "How paging by JDBC ?" New topic
Author

How paging by JDBC ?

Yang XZ
Greenhorn

Joined: Apr 26, 2004
Posts: 1
We making a local java application, there is a screen for display the search results. but, the data is too much. so, I hope use Statement (setFetchSize())paging.
Can you help me ! thanks very much!
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61420
    
  67

"Yang XZ",
We're really glad that you are here with us in the JDBC forum, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

There are better ways to achieve this. Do a search in this forum for "ResultSet paging" and have a look at some of the discussions.
Dave
Lavern Matthew
Ranch Hand

Joined: Jun 05, 2004
Posts: 38
Take a look at the http://valuelist.sourceforge.net project.


Matthew Wilson<br />-http://valuelist.sourceforge.net
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How paging by JDBC ?