Microsoft has released a preview of the upcoming Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver is available to all SQL Server users and provides access to SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Azure 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. and 6.
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 6.0
· SQL Server 2012, 2008 R2, 2008, 2005 or Azure
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
Find us on Google+
