JDBC.jl icon indicating copy to clipboard operation
JDBC.jl copied to clipboard

Table-Valued parameters for SQL server

Open dmitrijsc opened this issue 8 years ago • 2 comments

Hi guys

Any plans to implement TVP for SQL server to support bulk load?

https://docs.microsoft.com/en-us/sql/connect/jdbc/using-table-valued-parameters#table-valued-parameter-api-for-the-jdbc-driver

dmitrijsc avatar Apr 05 '17 16:04 dmitrijsc

I hadn't seen this functionality before, doesn't seem like a standard JDBC facility, seems specific to SQL server. Which is not to say it can't be supported, just that it will take some investigation, and I can't promise when I'll be able to get to that.

For the moment, it might be possible to get to that via direct JavaCall invocations.

aviks avatar Apr 12 '17 08:04 aviks

You are correct. It is specific to SQL server. Hope you will find a time to look into it :)

dmitrijsc avatar Apr 17 '17 11:04 dmitrijsc