Pete Freitag Pete Freitag

jTDS - Open Source Type 4 JDBC Driver for SQL Server

Published on November 12, 2004
By Pete Freitag

If your looking for a JDBC driver for SQL Server that will work on multiple platforms, and is free - take a look at jTDS. The jTDS project also claims that it is the fastest JDBC driver for SQL Server, based on these benchmarks. Though the benchmarks doesn't include the DataDirect Drivers that ColdFusion MX is bundled with, nor the JTurbo driver that BlueDragon is bundled with.

I have been using this driver for about a year now in a standalone batch java utility I wrote, and I have not had any problems connecting to SQL Server 7 or 2000 with the driver.

From the site:

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12). jTDS is based on the work of the FreeTDS project and is currently the fastest complete JDBC driver for SQL Server and Sybase. Starting with release 0.9 jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, multiple concurrent (completely independent) Statements per Connection and implementing all of the DatabaseMetaData and ResultSetMetaData methods. Check out the feature matrix for more details.

Quite a few of the commercial JDBC drivers out there are based on jTDS (or FreeTDS), even if they no longer acknowledge this. jTDS has been tested with virtually all of the available JDBC-based database management tools and is the driver of choice for most of these (it is distributed with Aqua Data Studio and DataDino as the driver for SQL Server). jTDS is also becoming a common choice for enterprise-level applications: starting with release 0.8-rc1 jTDS passes the Hibernate test suite, making it the driver of choice for SQL Server.

jdbc jtds sqlserver

jTDS - Open Source Type 4 JDBC Driver for SQL Server was first published on November 12, 2004.

Discuss / Follow me on Twitter ↯



have you compared this with the merant drivers? A friend of mine had to setup MS SQL server as a JDBC datasource so they could overide default settings for the drivers and ms sql server (locking and transaction issues) and have experianced major performance issues. I am wondering if this may be a solution for them.
by robi on 11/19/2004 at 4:55:37 PM UTC

I was able to get the driver installed on CFMX standard and working. The odd thing is that now, whenever I call a wddx function I experience the following error:

Exception during WDDX operation.

That was thrown during a cfwddx call. Have you experienced anything like this, or been able to use this driver with CFMX v61 Standard?
by Abraham Lloyd on 11/19/2004 at 5:27:34 PM UTC
That's very odd, have you been able to reporduce that on another server? I wouldn't think a JDBC driver would have anything to do with WDDX functions. Did you somehow delete a jar file entry when you changed the classpath?

I will try it out when I get a chance.
by Pete Freitag on 11/19/2004 at 5:31:26 PM UTC

I haven't compared with Marant, I would guess they also do not allow you to post benchmark info. But I should look into it and see if that is indeed the case, and if not I will do some tests.

by Pete Freitag on 11/19/2004 at 5:33:05 PM UTC
Thanks Pete. I am acutally going to download it now for something else. Would love to see some stats.
by Robi on 12/11/2004 at 7:22:46 PM UTC
i have installed jtds for talking to my sql server but i keep getting a network error...connection refused...someone please suggest a way out...
by shalaka on 08/19/2006 at 4:02:28 PM UTC