-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 David,
David Smith wrote: > There's no JDBC setting. Sure there is: Statement.setFetchSize(int size) "Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint is ignored. The default value is zero." http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#setFetchSize(int) Mohammed, While JDBC supports sending results in certain-sized chunks, you should evaluate how you actually want to do your paging. If you leave a connection open between requests to allow the JDBC-based paging to (maybe) help out, then you will be putting a resource strain on your server since you'll have to leave connections open for a long time, bound to a certain user or session. > I'd recommend you take a close look at the > SELECT statement for your database for syntax to support paging. This is a better idea. Instead of issuing a single SELECT and then paging through the results, issue the same SELECT multiple times (once per page) and then instruct the server to return only results X through Y. Most RDBMSs support requests for subsets or results (for instance, in MySQL, you use the LIMIT keyword). - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGkmJT9CaO5/Lv0PARAkeEAJ4zXuYF+86uI9jRs3Gquu5P+yshkACfaBpV eD6YGnFK87y96eyoltJdIIA= =lplq -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]