SQL Server JDBC Driver Microsoft 4.0.  

Microsoft has released a preview of the upcoming Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 3.0 CTP download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000, SQL Server 2005, and SQL Server 2008 from any Java application, application server, or Java-enabled applet.

Microsoft SQL Server JDBC Driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.

This technology preview of the JDBC Driver now supports features that were added in SQL Server 2008. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, and JBoss.

Requirements:



· The JDBC driver is designed to work on any operating system that supports the use of a Java Virtual Machine (JVM). However, only Sun Solaris, SUSE Linux, and Windows XP or later operating systems have been tested.

· Java Development Kit: 5.0 or later

· SQL Server 2008 or SQL Server 2005 or SQL Server 2000

What's New in This Release: [ read full changelog ]



· 1765616 DatabaseMetadata.getTypeInfo now returns new java.sql.Type values for date, time, datetime2, datetimeoffset for katmai and higher versions

· 1764334 Added support for tracing of JDBC XA Timeout and XIDs

· 1750318 SQLServerDatabaseMetaData functions would now work correctly when a pooled connection is re-used.

· 1768845 The behaviour of setTimestamp and updateTimestamp are made consistent with respect to rounding. The data will be rounded to 7 decimals first by the driver before it is sent to the server.

· 1770134 updateTime on a time backend type with the max value(23:59:59.999) now results in correct rounding behavior

· 1761042 DataSource Boolean properties now log exit calls

· 1750330 Updated XA SQL Script to avoid misleading errors on first run

· 1761393 Improved tracing for unwrap methods

Version History
Version Microsoft 4.0.1427.2 added on: 12 Sep 2011



Changes on the new version:
What's new in Microsoft SQL Server JDBC Driver 4.0.912.1: January 24th, 2011

· 1765616 DatabaseMetadata.getTypeInfo now returns new java.sql.Type values for date, time, datetime2, datetimeoffset for katmai and higher versions
· 1764334 Added support for tracing of JDBC XA Timeout and XIDs
· 1750318 SQLServerDatabaseMetaData functions would now work correctly when a pooled connection is re-used.
· 1768845 The behaviour of setTimestamp and updateTimestamp are made consistent with respect to rounding. The data will be rounded to 7 decimals first by the driver before it is sent to the server.
· 1770134 updateTime on a time backend type with the max value(23:59:59.999) now results in correct rounding behavior
· 1761042 DataSource Boolean properties now log exit calls
· 1750330 Updated XA SQL Script to avoid misleading errors on first run
· 1761393 Improved tracing for unwrap methods