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 t

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 stateme

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

2004-08-18 Thread Daxin Zuo
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)? With Oracle, we can set it in program. Thanks. - To unsubscribe, e-mail: [EMAIL PROTE