On Wed, Aug 18, 2004 at 04:50:32PM -0700, Daxin Zuo wrote: : I use JDBC in JSP/Java with MS SQL Server. : Is there a way to set the Fetch Size (set to 10, 100,..) of ResultSet (as : ADO CacheSize in ASP)?
This sounds like a configuration specific to your database, either with a custom SQL statement (a la HSQLDB) or with a JDBC URL param... Unless you mean you want to limit the results using the clause "LIMIT x" in your SQL. -QM -- software -- http://www.brandxdev.net tech news -- http://www.RoarNetworX.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
