Microsoft SQL Server JDBC Driver 3.0

Microsoft SQL Server JDBC Driver 3.0 official address: http://www.microsoft.com/downloads/zh-cn/details.aspx? FamilyID = a737000d-68d0-4531-b65d-da0f2a735707

For MySQL 2.0, the support for SQL server 2008 R2.

Changes from 2.0 to 3.0:

327029 the "sqljdbc_auth.dll failed to be loaded" exception now contains more information about the cause of failure.

329180 the application server can now use the Wrapper interface to implement the proxy of the SQLServerDataSource instance and other classes that implement the Wrapper interface.

293533 when lastUpdateCount = true, the returned values of stored procedures executed by the table trigger no longer affect the UPDATE count of INSERT, UPDATE, or DELETE queries.

345336 Statement. close () after the basic connection is accidentally closed, the infinite loop problem has been solved.

351393 executeUpdate now returns the correct update count for the bulk insert query.

327052 when implicit cursor conversion produces result sets that are not supported by server cursors, ResultSet. getHoldability () returns ResultSet. HOLD_CURSORS_OVER_COMMIT.

374320 when the method encounters lock timeout or other row errors, the infinite loop problem in ResultSet. close () has been solved.

373923 the driver now uses the TLS Protocol for its SSL communication to comply with the federal information processing standard (FIPS ).

376322 the driver is now connected to the Failover partner used as the primary key in the Kerberos environment.

305612 ResultSet. getInt ("DATA_TYPE") does not cause NullPointerException of the table SQL type.

411695 getSchemas should return the schema information. In previous versions, the driver returned user information instead of Architecture Information. Now, according to the JDBC specification, the driver returns the schema information and supports schema name matching.

Example:

JDBC Driver For SQL2000/2005/2008

How to connect to SQL Server using windows integration in java