目前微软官方提供的SQL Server JDBC的最后版本为1.0,但是该版本的驱动有许多bug,今天得到的这个1.1版本的驱动是微软JDBC小组内部发行的一个版本,解决了许多已知的bug,比如:
Bug Details: Statement.execute() returns incorrect results for stored procedures
http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=dc43eb80-69b5-4137-8671-9f4e813ce259Bug Details: JDBC 2005 GA Driver error when running a callablestatement on SQLServer 2000
http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackid=3fcf439d-79ed-44d9-bbbf-320e4ee25d89
Exception Message: “SQL Error: A server cursor is not allowed on a remote stored procedure or stored procedure with more than one SELECT statement. Use a default result set or client cursor”Bug Details: JDBC Driver executeBatch does not work with INSERT statement
http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackid=e13a8009-7466-4803-ba19-6bfd4b5f8966
Exception Message: “java.sql.BatchUpdateException: com.microsoft.sqlserver.jdbc.SQLServerException: sp_cursoropen/sp_cursorprepare: The statement parameter can only be a single select or a single stored procedure.“Bug Details: SQL2005 JDBC Driver bug with time zone handling **Available as a QFE**
http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackid=e73c8b79-53a6-4779-98f1-71c0043179eb
如果需要的可以在下面留言。
现在微软官方已经推出了新的正式版的1.1版本的驱动,大家可以在官方下载:http://msdn.microsoft.com/data/ref/jdbc/