This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
if you are looking for ways to fetch 10 records, then fetch the next ten, etc... like some web pages, then have a look at this article which discusses this in detail. If you only want the first X number of rows, and that's it, have a look at the Statement.setMaxRows() method Jamie
Joined: Jan 30, 2002
thanks for reply, I really want to look for ways to fetch 10 records, then fetch the next ten, etc... I read the JDBC 2.0 API, and not sure Statement.setFetchSize(10); Statement.setFetchDirection(forward); can deal with my problem? Does anyone use this and know what the exactly above function's usage? thanks Krussi
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com