Welcome to MSDN Blogs Sign in | Join | Help

Microsoft JDBC Driver Team Blog

Discussions related to Microsoft JDBC driver.
SQL Server JDBC driver v2.0 beta is now available

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 http://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

Posted: Wednesday, July 23, 2008 11:48 AM by dpblogs
Filed under: , ,

Comments

John said:

Will this version work with SQL Server 2008?

# August 4, 2008 2:24 PM

dpblogs said:

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.

# September 9, 2008 9:09 PM

Binesh said:

How long will take for new JDBC Drver to support SQL server 2008 latest data type

# September 23, 2008 12:42 AM

John Newman said:

Does this not support resultSet.getSQLXML(1); ?

Any idea when we'll see that?  This is so important

# September 24, 2008 1:26 PM

dpblogs said:

Hi John,

Support for resultSet.getSQLXML() will be available in our next CTP/Beta.

Regards,

Jimmy Wu

# September 25, 2008 2:31 PM

Ken Reitz said:

Is there a release date set for the resultSet.getSQLXML() support?  Any suggestions on what to do while this is being developed?

Thanks,

Ken

# October 8, 2008 1:47 PM

Sagar I said:

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.

# December 6, 2008 6:19 AM

wesclark said:

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.

# January 13, 2009 2:24 PM

Xavier Ronteix said:

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

# January 15, 2009 7:22 AM

dpblogs said:

Wes,

We are targetting the v2.0 release for Q1 2009.

# January 15, 2009 12:35 PM

Reinhold Jaekle said:

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?

# January 30, 2009 4:02 AM

Mugunthan Mugundan - MSFT said:

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.

# January 30, 2009 10:48 AM

wesclark said:

Does the RTM release still look good for this month?

# March 13, 2009 11:14 PM

dpblogs said:

# March 31, 2009 5:20 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker