Removed unused Java 9-specific class references from the Java 8 jar #1626.Send the client process ID to the server when running on Java 9+ #1595.Appended the MSAL exception error message to the error string returned during Azure AD authentication failures #1576.Updated error messages for Always Encrypted with secure enclave exceptions to link to a troubleshooting guide #1585.Added sending the driver version to the database during prelogin #1583.
Added support for multiple, successive connections using different settings for the Azure Key Vault key store provider #1594. Added server recognition for Azure Synapse serverless SQL pool, and Azure SQL Edge #1543. Added Open Connection Retry feature #1535. Added support for replication connections via a replication connection string option #1566. Added optional realm connection string property for Kerberos authentication #1581. Version 9.4.0 brings several added features, changes, and fixed issues over the previous production release. 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.Version 9.4 of the Microsoft JDBC Driver for SQL Server has been released. 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). Quite a few of the commercial JDBC drivers out there are based on jTDS (or FreeTDS), even if they no longer acknowledge this. Check out the feature matrix for more details. 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. jTDS is based on the work of the FreeTDS project and is currently the fastest complete JDBC driver for SQL Server and Sybase. 
JTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 20) and Sybase (10, 11, 12).
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. Though the benchmarks doesn't include the DataDirect Drivers that ColdFusion MX is bundled with, nor the JTurbo driver that BlueDragon is bundled with. The jTDS project also claims that it is the fastest JDBC driver for SQL Server, based on these benchmarks. If your looking for a JDBC driver for SQL Server that will work on multiple platforms, and is free - take a look at jTDS.
0 kommentar(er)
