Re: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

2004-08-20 Thread John Villar
that's true i really like some of their products its a shame that their blind effort to deny something like linux is only going to leave them behind in the long run or not so long? 8-) The MS app-dev product line has many hooks into the OS itself. That would bring about several (lar

Re: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

2004-08-20 Thread QM
On Fri, Aug 20, 2004 at 09:29:02AM -0400, John Villar wrote: : Something off topic, does anyone has wondered why M$ hasn't developed : its server line for linux? i know the usual response "They want you to : buy W2K Server", but that would be superficial thinking Do you mean its .NET environ

Re: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

2004-08-20 Thread John Villar
ed using this on a project with sql server with the native driver and it made a huge improvement -Original Message- From: John Villar [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 August 2004 10:26 PM To: Tomcat Users List Subject: Re: Is there a way to set the size of ResultSet from MS SQL

Re: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

2004-08-20 Thread John Villar
faster than the MS driver. Allistair Crossley -Original Message- From: Brad McEvoy [mailto:[EMAIL PROTECTED] Sent: 20 August 2004 01:17 To: 'Tomcat Users List' Subject: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r thats true, but now i t

RE: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

2004-08-20 Thread Allistair Crossley
bject: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet > from MS SQL Serve r > > > > thats true, but now i think about it, why would anyone use > the JDBC driver > to connect to SQL Server? The JDBC driver is the worst one > i've used and the > MS na

[OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

2004-08-19 Thread Brad McEvoy
Original Message- From: John Villar [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 August 2004 10:26 PM To: Tomcat Users List Subject: Re: Is there a way to set the size of ResultSet from MS SQL Serve r However, that would work only if the driver you're using uses the FetchSize as a hin

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

2004-08-19 Thread John Villar
However, that would work only if the driver you're using uses the FetchSize as a hint for caching records. In JDBC caching is primarily the responsability of the Driver. Brad McEvoy escribió: something like this should do the trick ... PreparedStatement pstmt = con.prepareStatement(sql,ResultSet

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

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