How to pass Table-Valued parameters from java to sql server stored procedure?
With the inputs provided by Mark Rotteveel I was able to do it. Thanks Mark, Sean thanks for your input as well. Here is the working code for any of you that may find it useful. String jdbcurl = “jdbc:sqlserver://TestServer:1433;DatabaseName=Student”; connection = DriverManager.getConnection(jdbcurl,”username”,”password”); SQLServerDataTable stuTypeDT = new SQLServerDataTable(); stuTypeDT.addColumnMetadata(“StudentId”, java.sql.Types.NUMERIC); stuTypeDT.addColumnMetadata(“Name”, java.sql.Types.VARCHAR); stuTypeDT.addColumnMetadata(“Department”, java.sql.Types.VARCHAR); stuTypeDT.addColumnMetadata(“Address”, … Read more