Table-Valued parameters for SQL server

JuliaDatabases / JDBC.jl

Julia interface to Java database drivers

Other

38 stars 19 forks source link

Table-Valued parameters for SQL server #25

Open dmitrijsc opened 7 years ago

dmitrijsc commented 7 years ago

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

aviks commented 7 years ago

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.

dmitrijsc commented 7 years ago

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