Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <41DC6B04.7070400@temple.edu>
Date: Wed, 05 Jan 2005 14:32:36 -0800
From: Dwayne Ghant <dghant@temple.edu>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.7.1) Gecko/20040707
MIME-Version: 1.0
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Subject: Re: Speed issues with SQL Server 2000 and JTDS
References: <CA44979F4F707E499D909DAC3464D9AC114030@ngsv24.my-netgain.com>
In-Reply-To: <CA44979F4F707E499D909DAC3464D9AC114030@ngsv24.my-netgain.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hey Charles,
I have implement a database driver that I found online
do you think it will help you out???


Charles P. Killmer wrote:

>I bought the Core Servlets and Java Server Pages and read it over the
>weekend.  Happy New Year to me.  I did get out to a few parties though.
>;)  I am having trouble getting JTDS to return results quickly. 
> 
>Has anyone got any example code for how to properly query a SQL Server
>2000 database?  The code I write needs to work with both SQL Server 2000
>and SQL Server 7.  In creating the connection, I am specifying
>TYPE_SCROLL_INSENSITIVE and TYPE_CONCUR_READ_ONLY.  I tried not
>specifying anything and got errors about not being able to scroll the
>results.  Is the only solution to this, use FORWARD_ONLY and buffer the
>contents myself?  I hoping there is a better way.
> 
>Thank you
>Charles Killmer
> 
>
>  
>


-- 

Dwayne A. Ghant
Application Developer
Temple University
215.204.5555
dghant@temple.edu

 
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org