Microsoft SQL Server JDBC Driver 3.0

Source: Internet
Author: User
Tags bulk insert how to connect to sql server
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.