The jTDS project has released version 1.2.7 and 1.3.0 of the open source JDBC driver for Microsoft SQL Server and Sybase. The new versions are a quite huge update, also fixing a number of critical bugs and improving the performance, so we'd highly encourage you to upgrade.

Version 1.3.0 is the first Java 7 compatible version of the driver and, beside the fix for bug #672, improves performance compared to version 1.2.7. The future development will be focused on the 1.3.x line of the driver, so further enhancements and bug fixes will not necessarily become available it the Java 1.3 compatible jTDS 1.2.x. You should only stick to jTDS 1.2 if you require to use a Java version prior to Java 7.... read more

The last driver release returned a wrong version String (1.2.5) in DatabaseMetaData.getDriverVersion(). The jTDS 1.2.6 realease files have been updated with a corrected version.

We apologise for the trouble caused.

The jTDS Project has released version 1.2.6 of the open source JDBC driver for
Microsoft SQL Server and Sybase. jTDS 1.2.6 is a maintenance release, correcting
a number of bugs and adding a few minor features.

Bug fixes:
o [3476715], parsing time values containing fractions of seconds may fail.
o Corrected a bug that could cause a call to JtdsStatement.close() to fail.
o Fixed a bug that could cause ResultSet cancellation to close the connection.
o [3141458], NPE if ResultSet.next()/ResultSet.close() are called concurrently.
o [3078236], Exception chaining time grows exponentially.
o [3081749], SSPIJNIClient.getInstance() wasn't thread-safe.
o Corrected a bug that caused a RuntimeException to mask a prior SQLException.
o Improved fix for bug [2931326], Statement.close() cannot throw NPE anymore.
o [2931326], NPE if Statement.close() is called by threads concurrently.
o [3002431], improved handling of port discovery errors.
o [3000472], TimerThread started when closing the last connection.
o Fixed method synchronization in TimerThread.

jTDS is the most performant JDBC driver for both Microsoft SQL Server and
Sybase. It is a complete implementation of JDBC 3.0, it passes the J2EE 1.3
certification and Hibernate test suites and is the preferred SQL Server/Sybase
driver for JBoss, Hibernate, Atlassian JIRA and Confluence, DbVisualizer and
Compiere.... read more

The jTDS Project has released version 1.2.5 of the open source JDBC driver for Microsoft SQL Server and Sybase. jTDS 1.2.5 is a maintenance release, correcting a number of bugs and adding a few minor features.

This release restores backward compatibility with Java 1.3.

Bug fixes:
o [2900139], NoClassDefFoundError with C3P0.
o [2856350]/[2898905], problems with JDBC4 stubs in GlassFish.
o [2911266], default response timeout of 30 seconds if using named pipes.
o [2892493], NullPointException when receiving character NULL values.
o [2891775], fix for bug [2340241] has broken Java 1.3 compatibility.
o [2883066], Numeric overflow in conversion BigInteger/BIGINT.
o [2871274], no soft kill for TimerThread.
o Corrected a bug that lead to login errors being masked by later exceptions.... read more

[The Sourceforge news system has been unavailable for some time, so this announcement has not been posted earlier. jTDS 1.2.4 has already been uploaded to Sourceforge on September 29 2009.]

The jTDS Project has released version 1.2.4 of the open source JDBC driver for Microsoft SQL Server and Sybase. jTDS 1.2.4 is a hotfix release, correcting critical bug [2860742].

Bug fixes:
o [2860742], getByte() causes overflow error for negative values.
o [2856350], JDBC4 method stubs make jTDS unusable.... read more

The jTDS Project has released version 1.2.3 of the open source JDBC driver for
Microsoft SQL Server and Sybase. jTDS 1.2.3 is a bugfix release, improving
upon jTDS 1.2.2. A few new features also made it into the release.

New features:
o [2340241] process ID can be passed as connection property
o [1778933] added support for socket keep-alive feature

Bug fixes:
o [2814376] varchar-type is truncated in non-unicode environment
o [2349058] DateTime allows invalid dates through
o [2181003] attempt to set a BC date invalidates internal state
o [2675463] jTDS returns database users instead of schemas
o [1855125] jTDS silently ignores integer overflows
o [1755448] login failure leaves unclosed sockets
o [1845477] missing license info
o [1955499] performance problems with timestamps in multi-threaded applications
o [1793584] login timeout canceled too early
o [1802986] incorrect charset mapping between 'MAC' and 'ISO-8859-1'
o [1957748] jTDS is leaking memory
o [2508201] date values are changed by 3 milliseconds
o [2796385] jTDS is running out of UDP sockets
o [1869156] jTDS is leaking memory
o [2021839] data truncation problem
o [1811383] ArrayIndexOutOfBounds on executeBatch
o [2021839] savepoint starts 2 transactions if it's the first operation
o [1843801] infinite loop if DB connection dies during a batch
o [2818256] a savepoint is invalid after rollback
o [1883905] unintentional infinite wait

Make sure to check the changelog for detailed listings of the bugfixes and new
features.

jTDS is the most performant JDBC driver for both Microsoft SQL Server and
Sybase. It is a complete implementation of JDBC 3.0, it passes the J2EE 1.3
certification and Hibernate test suites and is the preferred SQL Server/Sybase
driver for JBoss, Hibernate, Atlassian JIRA and Confluence, DbVisualizer and
Compiere.

For more information on jTDS see:

http://jtds.sourceforge.net/

The release can be downloaded from:

https://sourceforge.net/project/showfiles.php?group_id=33291

Open source JDBC 3.0 Type 4 driver for Microsoft SQL Server (6.5, 7.0, 2000 and 2005) and Sybase. jTDS is the fastest JDBC driver for MS SQL Server and is a complete implementation of the JDBC spec. For more information see http://jtds.sourceforge.net/

The jTDS Project has released version 1.2.2 of the open source JDBC driver for
Microsoft SQL Server and Sybase. jTDS 1.2.2 is a bugfix release, improving over
upon jTDS 1.2.1. A few new features also made it into the release.

New features:
o 64-bit support for Single Sign On (SSO)
o [1491811] sqlState code for snapshot conflict.

Bug fixes:
o [1774322] Sybase nulled text fields return not null
o [1592113] NTLMv2 properties on datasource ... read more

The jTDS Project has released version 1.2.1 of the open source JDBC driver for Microsoft SQL Server and Sybase. jTDS 1.2.1 is a bugfix release, improving over the very successful jTDS 1.2. A few new features also made it into the release.

New features:
o Support for specifying the bind address
o Support for SNAPSHOT transaction isolation
o NTLMv2 authentication
o Support for specifying the disk buffer directory.

Bug fixes (partial list):
o Statement memory leak
o SQLException thrown in CallableStatement SetByte()/setDouble()/setFloat()
o Single blank space returned as empty string
o Execute batch returning incorrect counts
o Default named pipe path for Sybase
o Named pipe connections across domains
o Concurrent batch update failure
o executeQuery absorbs thread interrupt status

Make sure to check the changelog for detailed listings of the bugfixes and new features.

jTDS is the most performant JDBC driver for both Microsoft SQL Server and Sybase. It is a complete implementation of JDBC 3.0, it passes the J2EE 1.3 certification and Hibernate test suites and is the preferred SQL Server/Sybase driver for JBoss, Hibernate, Atlassian JIRA and Confluence, DbVisualizer and Compiere.

For more information on jTDS see http://jtds.sourceforge.net/

The release can be downloaded from:
https://sourceforge.net/project/showfiles.php?group_id=33291

The jTDS Project has released version 1.2 of the open source JDBC driver for
Microsoft SQL Server and Sybase. jTDS 1.2 is a major bugfix release, improving
over the very successful jTDS 1.1. A few new features, such as support for
Sybase ASE 15, SQL Server 2005 and improved exceptions also made it into the
release.

New features:
o Support for Sybase ASE 15
o Improved support for SQL Server 2005 varchar(max) and varbinary(max)
o Complete handling of cursor exceptions and downgrading
o Better handling of cancels and timeouts
o Configurable socket timeout
o Subclasses of basic JDBC types recognized as setObject() values... read more

The jTDS Project has released version 1.1 of the open source JDBC driver for Microsoft SQL Server and Sybase. jTDS 1.1 is a major feature release, notable new features including much improved statement caching, configurable metadata caching, optimistic/pessimistic locking support and fast forward-only cursors.

Other major changes are the switch to sp_prepare as default prepare method for prepared statements instead of temporary stored procedures -- which means better performance and no more depending on transaction rollbacks -- and optimistic concurrency instead of row locks on default updatable result sets.... read more