jTDS is Free Software. jTDS is released under the terms of the GNU Lesser
General Public License. A copy of the LGPL is provided in the LICENSE file. The
LGPL is sufficiently flexible to allow the use of jTDS in both open source and
This document has been superseded by the HTML documentation that can be found
in the html directory. However, since it still contains pertinent information
it has been left in place. If you are a first time user please read this
document and the HTML FAQ before proceeding. It's also recommended that you
also read at least part of the HTML documentation.
jTDS is released under the terms of the LGPL. A copy of the LGPL is provided
in the LICENSE file.
jTDS is based on software written by the FreeTDS project that can be found at
http://www.freetds.org/. Much kudos goes to the developers of that software.
Lots of thanks go to SourceForge.net, who in a big part made possible the very
existence of jTDS.
Stable for concurrent usage (Connections are multithread-safe, Statements are
completely independent). Full support is provided for forward-only and
scrollable/updateable ResultSets, PreparedStatements, and CallableStatements.
A DataSource, a ConnectionPoolDataSource and an experimental XADataSource
implementation are also provided. All of these are implemented by class
Meta data information is 99.99% complete and accurate (both ResultSetMetaData
and DatabaseMetaData). ParameterMetaData support is partial, some methods
return the same value (which is acceptable, according to the JDBC spec).
jTDS is used in a number of commercial applications. It has been tested with and
is actually recommended as the driver to use for MS SQL Server by pretty much
all open source AND commercial database management tools:
o iSQL-Viewer (http://isql.sourceforge.net)
o SQL Workbench/J (http://www.sql-workbench.net)
o SQuirreL SQL Client (http://squirrel-sql.sourceforge.net)
o Db-Visualizer (http://www.minq.se/products/dbvis/index.html)
o SQL Developer (http://sqldeveloper.solyp.com, really nice tool).
o Artiso Visual Case (http://www.visualcase.com)
There are quite a few database management tools that come bundled together with
o DataDino (http://www.datadino.com/)
o DBInspect (http://www.dbinspect.com/)
o Aqua Data Studio (http://www.aquafold.com/)
o DB Viewer (http://victorpendleton.net/products/dbviewer.html)
For more information about jTDS check out the project's homepage
Please see the FAQ page for a more detailed explanation of the URL format and
the supported URL properties.
1. Locator-based Blob/Clob implementation.
2. Minor features, such as failover support.
jTDS homepage: http://jtds.sourceforge.net/
SourceForge project info: http://sourceforge.net/projects/jtds/
These are the steps you should follow to run the JUnit tests provided with jTDS
(they are included in the source package, along with some reverse-engineering
1. Duplicate conf/connection.properties.tmpl as conf/connection.properties.
2. Modify conf/connection.properties to point to your server/database, and put
in your username and password. Most of the tests use only temporary tables, so
almost any user should do (there are a few tests that need to create permanent
tables but they also delete them so you should not end up with garbage in your
3. Set the JAVA_HOME system property to point to your Java installation
4. In a command prompt, type:
This will run a series of JUnit tests on your database. All tests should pass
normally. If any of them fails, please let us know about it (along with the
particular system configuration you were using).