Call stored procedure with table-valued parameter from java

by

This is documented here in the JDBC driver manual. In your case, you’d have to do this:

try (SQLServerCallableStatement stmt =
    (SQLServerCallableStatement) con.prepareCall("{call test(?)}")) {

    SQLServerDataTable table = new SQLServerDataTable();   
    sourceDataTable.addColumnMetadata("n", java.sql.Types.INTEGER);   

    sourceDataTable.addRow(9);
    sourceDataTable.addRow(12);
    sourceDataTable.addRow(27);
    sourceDataTable.addRow(37);

    stmt.setStructured(1, "dbo.integer_list_tbltype", table);  
}

I’ve also recently documented this in an article.

More Related Contents:

  1. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?
  2. Insert results of a stored procedure into a temporary table
  3. How to SELECT FROM stored procedure
  4. Function vs. Stored Procedure in SQL Server
  5. Parameterize an SQL IN clause
  6. What is a stored procedure?
  7. How to assign an exec result to a sql variable?
  8. SQL Call Stored Procedure for each Row without using a cursor
  9. SQL Server SELECT into existing table
  10. How to check if a stored procedure exists before creating it
  11. Execute Stored Procedure from a Function
  12. SQL: Select dynamic column name based on variable
  13. SQL : in clause in stored procedure:how to pass values
  14. Can we pass parameters to a view in SQL?
  15. SQL Server silently truncates varchar’s in stored procedures
  16. Split values over multiple rows [duplicate]
  17. How do I pass a list as a parameter in a stored procedure?
  18. Must declare the scalar variable
  19. Why execute stored procedures is faster than SQL query from a script?
  20. “Order By” using a parameter for the column name
  21. Stored procedure that exports data into csv files only exports to one file
  22. Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
  23. Insert Update stored proc on SQL Server
  24. SQL Server: should I use information_schema tables over sys tables?
  25. UNION the results of multiple stored procedures
  26. How to pass a temp table as a parameter into a separate stored procedure
  27. Eliminate and reduce overlapping date ranges
  28. Functions vs Stored Procedures
  29. How to execute a stored procedure inside a select query
  30. Check if a parameter is null or empty in a stored procedure

Leave a Comment