Microsoft SQL Server 2005 JDBC Driver 1.1 CTP II is live!

   Today we released JDBC Driver 1.1 CTP 2. The release contains bug fixes and two new features since v1.0, Database Mirroring and Integrated Authentication. I will be posting an example to demonstrate how to use Database Mirroring. In the meantime, the JDBC dev team here at Microsoft would love to hear feedback from you.

      Download CTP 2: https://msdn.microsoft.com/data/ref/jdbc/default.aspx

The bug fixes for this release are mainly focused around XA Transaction behavior, Timezone and DST handling, Boolean getters, PreparedStatement executions and Statement cancellation. Following is a shortened list of the bugs we fixed for this release. 

409319 Cancelling statement execution works from any thread without closing the connection.

423881 The driver properly returns update counts from triggers.

433170 Several aspects of XA transaction behavior have been corrected.

450355 getBoolean on a CHAR/VARCHAR/NVARCHAR column with a value of "1" returns true instead of false.

430837 Connections obtained from SQLServerXADataSource may be used in local transactions while they are outside the scope of an XA transaction.

425030 The driver correctly handles setting and retrieving dates, times and timestamps with time zones other than the system default.

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.