Microsoft SQL Server 2005 JDBC Driver

Release Information Microsoft SQL Server 2005 JDBC Driver 1.1 August 2006 INTRODUCTION ------------ This file contains late-breaking or other important information that supplements the Microsoft SQL Server 2005 JDBC Driver documentation. You should read this file completely before installing the JDBC driver. Your feedback is very important to us and we will strive to respond to your feedback in a timely manner. For information about providing feedback by using the JDBC driver newsgroup and online forums, see the Microsoft SQL Server 2005 JDBC Driver page at http://msdn.microsoft.com/data/ref/jdbc. INSTALLATION ------------ Instructions for installing the JDBC driver are located in install.txt. Refer to that file for information about installing the JDBC driver on Windows and Unix operating systems. RELEASE CONTENTS ---------------- The Microsoft SQL Server 2005 JDBC Driver executable zip or tar file unpacks the following files in the specified locations, relative to the selected installation directory: <installation directory>\sqljdbc_<version>\<language>\install.txt <installation directory>\sqljdbc_<version>\<language>\release.txt <installation directory>\sqljdbc_<version>\<language>\license.txt <installation directory>\sqljdbc_<version>\<language>\sqljdbc.jar <installation directory>\sqljdbc_<version>\<language>\auth\x86\sqljdbc_auth.dll <installation directory>\sqljdbc_<version>\<language>\auth\x64\sqljdbc_auth.dll <installation directory>\sqljdbc_<version>\<language>\help\default.htm <installation directory>\sqljdbc_<version>\<language>\help\index.htm <installation directory>\sqljdbc_<version>\<language>\help\toc.htm <installation directory>\sqljdbc_<version>\<language>\help\html\<doc pages...> <installation directory>\sqljdbc_<version>\<language>\help\local\<doc files...> <installation directory>\sqljdbc_<version>\<language>\help\samples\<sample files...> <installation directory>\sqljdbc_<version>\<language>\xa\xa_install.sql <installation directory>\sqljdbc_<version>\<language>\<loc>\xa\x86\sqljdbc_xa.dll <installation directory>\sqljdbc_<version>\<language>\<loc>\xa\x64\sqljdbc_xa.dll CHANGE LIST ----------- The following is a list of changes that have been made in the Microsoft SQL Server 2005 JDBC Driver since the version 1.0 release in January 2006. 409319 Canceling statement execution works from any thread without closing the connection. 423894 Sun CTS: DatabaseMetaData.getNumericFunctions no longer returns MOD in the list of supported functions for SQL Server 2000. 426389 Calling Statement.execute no longer causes an SQLException with the message "sp_cursoropen/sp_cursorprepare: The statement parameter can only be a single select or a single stored procedure" for UPDATE WHERE queries when the selectMethod=cursor connection property is set. 436718 Calling PreparedStatement.execute no longer causes an SQLException with the message "sp_cursoropen/sp_cursorprepare: The statement parameter can only be a batch or a stored procedure with a single select, without FOR BROWSE, COMPUTE BY, or variable assignments" for INSERT INTO queries when the selectMethod=cursor connection property is set. 434562 Appropriate JDBC types are now reported in the DATA_TYPE column from various metadata calls for GUID, NCHAR, NVARCHAR, and NVARCHAR(max) SQL Server types. These are sql.types.char, sql.types.varchar, and sql.types.longvarchar, respectively. 450639 The driver no longer throws an SQLException with the message "Server failed to resume the transaction, desc: 4600000001." when configuring SQL Server 2005 as the JBoss JMS message store. 425030 The driver correctly handles setting and retrieving dates, times, and timestamps with time zones other than the system default. 432090 Executing the statement DBCC SHOW_STATISTICS produces the correct set of result sets. 429427 Calling CallableStatement.clearParameters no longer causes a NullPointerException on a subsequent call to retrieve an OUT parameter value. 433170 Several aspects of XA transaction behavior have been corrected. 438767 The behavior of the getTime and getDate methods with Calendar objects and values around daylight saving time (DST) transitions in different time zones and locales has been corrected. 422875 PreparedStatement.setObject and ResultSet.updateObject with scale will scale numeric values correctly. 435796 Executing SQL WRITETEXT statements no longer throws an SQLException with the message "No TDS_RET_STATUS was found for the stored procedure output parameters." 424295 DatabaseMetaData.getMaxConnections no longer throws an SQLException with the message "The configuration option 'user connections' does not exist, or it may be an advanced option" for SQL Server 2005 servers. 423881 The driver correctly returns update counts from triggers. 20012145 The driver sets the transaction mode in a SQL Server database and correctly reports the driver's autocommit mode when the Connection.setAutoCommit method is called. 428803 Executing a statement after setting a binary or character stream with an actual length that differs from the one passed to the setter no longer closes the connection after throwing the appropriate SQLException. 430837 Connections obtained from SQLServerXADataSource can be used in local transactions while they are outside the scope of an XA transaction. 20012126 The BIGINT SQL type is used for sending java.sql.BIGINT prepared statement parameter values to a SQL Server database, which results in a more efficient query execution plan. 428197 Batch execution of prepared statements works correctly when there is more than one item in the batch. 426966 Handling of double quote-delimited literals in SQL statements has been improved. 429085 Historical changes in daylight saving time (DST) in all time zones are correctly handled. 433394 Calling Statement.executeBatch after setting a BLOB value no longer throws an SQLException with the message "The conversion from BLOB to BINARY is unsupported." 435448 The driver no longer throws an SQLException with the message "com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '-'" when sending a BigDecimal prepared statement parameter value to the server with the 5.0 JRE. 423733 ResultSet.rowDeleted no longer throws an ArrayIndexOutOfBounds exception after a call to ResultSet.beforeFirst or ResultSet.afterLast. 429214 Unused portions of java.sql.Time and java.sql.Date objects are normalized to the correct values. 424450 Sending a binary or ASCII stream value that is between 4022 and 4025 bytes long to a varbinary(max) column in a SQL Server 2005 server no longer throws an IndexOutOfBoundsException. 428725 Fractional numeric values are correctly truncated by getter methods when converting to integral types. 432590 Sending an ASCII stream longer than 4000 characters to the server by using the PreparedStatement.setObject method as Type.VARCHAR sends the entire stream rather than truncating it at 4000 characters. 445528 The SQLServerResultSet.getBoolean method is supported only on number and character data types. It converts values "1", 1, and "true" to true, and values "0", 0, and "false" to false. For all other values the behavior is undefined. 421916 The setObject(parameter, null) methods of the SQLServerPreparedStatement and the SQLServerCallableStatement classes no longer throw a NullPointerException. See the setObject API topics in the JDBC help system for more i