You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Charles P. Killmer" <ch...@netgaintechnology.com> on 2005/01/02 22:13:16 UTC
Speed issues with SQL Server 2000 and JTDS
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
Re: Speed issues with SQL Server 2000 and JTDS
Posted by Dwayne Ghant <dg...@temple.edu>.
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