Brad , thank you. It seems the trick I am looking for. -----Original Message----- From: Brad McEvoy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 9:24 PM To: 'Tomcat Users List' Subject: RE: Is there a way to set the size of ResultSet from MS SQL Server
something like this should do the trick ... PreparedStatement pstmt = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_O NLY); pstmt.setFetchSize(100); ResultSet rs = pstmt.executeQuery(); ... -----Original Message----- From: QM [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 August 2004 2:04 PM To: Tomcat Users List Subject: Re: Is there a way to set the size of ResultSet from MS SQL Server 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]