Share via

SQL Server JDBC driver v2.0 beta is now available

  • Article

We are proud to announce the availability of our beta v2.0 driver with support for JDBC 4.0 National Character Set JDBC data types and API methods among others.  We have also enhanced our built-in tracing leveraging the Java logger utility by adding method entry and exit traces and better differentiation between the logger levels.

The beta driver is available at https://msdn.microsoft.com/data/jdbc

We welcome all feedback as we continue to improve this driver for the community.

Jimmy Wu
SQL Server JDBC Team

Comments

  • Anonymous
    August 04, 2008
    Will this version work with SQL Server 2008?

  • Anonymous
    September 09, 2008
    This version is focused on supporting the JDBC 4.0 API.  It does connect and work with SQL Server 2008, but it is not a SQL Server 2008 JDBC driver.

  • Anonymous
    September 22, 2008
    How long will take for new JDBC Drver to support SQL server 2008 latest data type

  • Anonymous
    September 24, 2008
    Does this not support resultSet.getSQLXML(1); ? Any idea when we'll see that?  This is so important

  • Anonymous
    September 25, 2008
    The comment has been removed

  • Anonymous
    October 08, 2008
    Is there a release date set for the resultSet.getSQLXML() support?  Any suggestions on what to do while this is being developed? Thanks, Ken

  • Anonymous
    December 05, 2008
    Will it support "Bulk Copy"? I was half way done porting the "Bulk Copy" using the current microsoft jdbc driver. Used the com.microsoft.jdbc.sqlserver.tds package to do that. and now when I look at your new classes, this package is gone, so I'll have to go back to JNI. Java applications deserves a "Bulk Copy" implementation, where one can call bcpInit, bcpSendRow, bcpBatch, bcpDone. without using the stupid file logic or JNI.

  • Anonymous
    January 13, 2009
    Is there a target release date for this driver?  We are using the 1.2 version at our customer sites, and would like to find a solution to the Logger.getLogger() synchronization problem (see http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/eaaed323-fbd7-4667-9d77-f3a4bc311a5a/), which is causing performance issues.  We aren't going to give them a CTP driver version, so we need either a production version of 2.0, or a fix to the synchronization problem in 1.2.  Thanks.

  • Anonymous
    January 14, 2009
    Have you a plan of the next CTP, or RTM version that will support SQL 2008 Server? As we encounter troubles wiht date/time.

  • Anonymous
    January 15, 2009
    Wes, We are targetting the v2.0 release for Q1 2009.

  • Anonymous
    January 29, 2009
    Will JDBC Driver 2.0  be able to create a connection in an Ipv6 network if "Server name" is given instead of an IPv6 address? Does the driver iterate through multiple Ipv6 address?

  • Anonymous
    January 30, 2009
    yes, you can use IPV6 address to connect with the JDBC driver. Further info http://msdn.microsoft.com/en-us/library/ms378428.aspx Connecting with IPv6 Addresses The JDBC driver supports the use of IPv6 addresses with the connection properties collection, and with the serverName connection string property. The initial serverName value, such as jdbc:sqlserver://serverName, is not supported for IPv6 addresses in connection strings. Using a name for serverName instead of a raw IPv6 address will work in every case in the connection. The following examples provide more information.

  • Anonymous
    March 13, 2009
    Does the RTM release still look good for this month?

  • Anonymous
    March 31, 2009
    Hey Wes, You can download the RTM here, it just went live today: http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en