Announcement and Discussions related to the Microsoft JDBC driver for SQL Server
SQL Server developer community thanks for all your input to date for our roadmap. I am the new Program Manager for Microsoft JDBC Driver for SQL Server and would like input while planning our next release.
In the past, we have had requests for both Table-Valued Parameters (TVP) as well as bulk copy API. We would like to understand which of these two is most important to your organization.
Please vote for the feature you would most like to see added to our JDBC driver.
To vote for TVP http://mssqlconn.uservoice.com/forums/113295-feature-feedback/suggestions/2269687-table-valued-parameters-tvp-support-in-jdbc
To vote for Bulk Copy API http://mssqlconn.uservoice.com/forums/113295-feature-feedback/suggestions/2269691-bulk-copy-api-support-in-jdbc
This data will help us to determine the priority of these two items for our roadmap. Also, please provide the specific scenarios in which you would like to use the feature via our blog or while voting in the User Voice forum.
Shamitha ReddyProgram Manager - Microsoft
Update January 2012
Thank you all for your feedback. Based on your votes and comments, we have added TVP to our roadmap. Bulk copy is still on our to do list as well.
Update March 2012For those of you who are interested in TVP, please provide us with more details on how you would use this feature. You can email us or comment on the following blog post.
can you submit jdbc driver on public maven repository?
Can you contact me via this link about Maven?
I see that TVP is currently winning. do you know if it will be included in the next release? And when the next release might be?
Based on user feedback we have added TVP to our roadmap. We still have bulk copy on our to do list as well.
There wouldn't happen to be a timeframe on when TVP will be available is there? We have a project beginning in May or June of this year that would really like to use TVP.
We do not have a date yet for when TVP support will be available in our driver. We are gathering requirements and use cases at this time. Any specific feedback you can give us on how TVP's will benefit you would be great. If you snippets of your current code where you would like to use TVP that would help as well.
We will have a message queue that our java code will be pulling off messages from and we would like to send all messages retrieved off of that queue in batch to a stored proc in SQL server via a TVP. So, ideally we would create a data set with each xml record being a separate row in the TVP and then our SP could handle those messages as a set.
By when we can expect a bulk copy API? If there are no plans to provide it in near future then are there any third party JDBC driver which provide bulk copy api for SQL Server?