How to pass Table-Valued parameters from java to sql server stored procedure?

by

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", java.sql.Types.VARCHAR);

stuTypeDT.addRow("1","Tom", "A", "123 Street");
stuTypeDT.addRow("2","Jery", "B", "456 Street");
stuTypeDT.addRow("3","Mac", "C", "Vancour");

String ececStoredProc = "EXEC InsertStudentInfo ?";
SQLServerPreparedStatement pStmt = (SQLServerPreparedStatement)connection.prepareStatement(ececStoredProc);
pStmt.setStructured(1, "dbo.StudentInfoType", stuTypeDT);
pStmt.execute();

More Related Contents:

  1. How do I connect to a SQL Server 2008 database using JDBC?
  2. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  3. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  4. JDBC connection failed, error: TCP/IP connection to host failed
  5. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  6. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  7. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  8. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  9. JPA SQL Server No Dialect mapping for JDBC type: -9
  10. Native Library sqljdbc_auth.dll already loaded in another classloader
  11. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  12. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  13. How to get *everything* back from a stored procedure using JDBC
  14. Getting the Return Value from JDBC MSSQL
  15. no sqljdbc_auth in java.library.path
  16. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  17. The TCP/IP connection to the host localhost, port 1433 has failed
  18. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  19. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  20. JDBC Class.forName vs DriverManager.registerDriver
  21. How to call oracle stored procedure which include user-defined type in java?
  22. SQL prepared statement how to select via multiple possible menu selections?
  23. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  24. Adding jdbc driver to classpath
  25. PreparedStatement setNull(..)
  26. ojdbc14.jar vs. ojdbc6.jar
  27. MySQL connector error “The server time zone value Central European Time” [duplicate]
  28. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  29. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  30. Postgres UUID JDBC not working

Leave a Comment