Re: JDBC Driver for SQL 2000 - Pls help
From: Alin Sinpalean (alin_at_earthling.net)
Date: 02/01/05
- Next message: John Bandettini: "RE: Database Healthchecks"
- Previous message: Syed: "RE: Urgent Help Please - Reclaiming unused but reserved space of"
- In reply to: Sanjay: "JDBC Driver for SQL 2000 - Pls help"
- Messages sorted by: [ date ] [ thread ]
Date: 1 Feb 2005 02:17:24 -0800
Sanjay wrote:
> One of the applications "Epistemic" which my client is using needs a
JDBC 3.0
> Compliant driver to connection to out SQL Server 2000 instance
>
> Questions
> 1. Is this driver available in installation of client software for
SQL
> Server 2000, if not where can i get it
The Microsoft driver is only a JDBC 2.0 implementation and it has a
number of problems, ranging from stability to performance, in which you
seem to be interested. E.g. if you need transaction support (which you
probably do) the MS driver will use server side cursors and will make a
request for each row you retrieve on a SELECT.
> 2. Like for ODBC we set up a profile in ODBC administrator, what do
we do
> for JDBC
Nothing, just drop the jar in the classpath and configure the URL in
your application.
> 3. Will accessing SQL 2000 through JDBC drive be any slower than
using OLEDB
> which is the default connectivity software for SQL Server 2000
With the MS driver, probably so. Try jTDS (
http://jtds.sourceforge.net/ ) instead. It's a JDBC 3.0 implementation,
it's way more stable than the MS driver and as fast as OLEDB.
Alin,
The jTDS Project.
Disclaimer: I am a jTDS developer so my views might not be totally
objective.
- Next message: John Bandettini: "RE: Database Healthchecks"
- Previous message: Syed: "RE: Urgent Help Please - Reclaiming unused but reserved space of"
- In reply to: Sanjay: "JDBC Driver for SQL 2000 - Pls help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
