RE: Is there a way to set the size of ResultSet from MS SQL Server

2004-08-19 Thread Daxin Zuo
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

Re: Is there a way to set the size of ResultSet from MS SQL Server

2004-08-18 Thread QM
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