Announcement and Discussions related to the Microsoft JDBC driver for SQL Server
The SQL Server JDBC team is happy to announce the release of the January 2009 community technology preview. This beta release is feature complete, which includes, but not limited to, JDBC 4.0 SQLXML data type; National Character set; driver autoloading; new metadata methods; and enhanced tracing. You can download the beta release at http://msdn.microsoft.com/data/jdbc.
Jimmy WuSQL Server JDBC Team
When do you expect a full, non-beta production release of this driver?
The JDBC v2.0 RTM is scheduled for Q1 2009.
PreparedStatement.setTimeStamp() don't support DateTime2 in the actual version 2.0.1607.1.
Will setTimeStamp() support DateTime in the final Release?
Thank-you for your feedback regarding wanting to see PrepareStatement.setTimeStamp() API support the SQL Server 2008 DateTime2 data type. The v2.0 release is focused on supporting the JDBC 4.0 API specification. While we do not currently support the DateTime2 data type, please read this blog entry (http://blogs.msdn.com/jdbcteam/archive/2008/09/28/working-with-sql-server-2008-date-time-data-types-using-v1-2-jdbc-driver.aspx). It discusses how to retrieve DateTime2 data types. You should be able to set the DateTime2 data type using the setString() function, assuming it is in the proper format.
We do have plans to support SQL Server 2008 data types in a future release of the driver, with the DateTime2 data type being one of them. We welcome suggestions regarding what SQL Server 2008 features we should support in the next release of our driver so please feel free to go ahead and voice your opinion here (http://blogs.msdn.com/jdbcteam/archive/2008/10/14/sql-server-2008-feature-support-survey.aspx).
SQL Server JDBC Team
When will you support spatial data types? It's impossible to use it for us without this basic function!
Jan, do you want just the spatial data or do you want the whole functionality provided by the spatial types. If the solution only works in Windows via the JDBC driver would that be acceptable to you?
is Microsoft still on track on having JDBC 2.0 RTM out in Q1?
JDBC has been released. We plan to make an official post sometime later today.