File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes SQL Server 2008 Table Valued Parameters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server 2008 Table Valued Parameters" Watch "SQL Server 2008 Table Valued Parameters" New topic
Author

SQL Server 2008 Table Valued Parameters

Tom Piersa
Greenhorn

Joined: Sep 25, 2009
Posts: 19
I've got a project that I need to call a SQL Server 2008 stored procedure that someone else wrote. I need to pass the stored procedure a User-Defined Table Type as input. I've never done this before. I've searched the internet. I've found lots of examples and articles on how to using C#. But nothing using java. The example in C# listed below breaks things down real simple. I don't know what the equivalent of a C# DataTable is in Java. I've worked with the ResultSet and PreparedStatement data types in java or sure if that's the right direction. I just can't make the connection. Any chance anyone could convert the last yellow box to java?

http://www.codeproject.com/Articles/22392/SQL-Server-2008-Table-Valued-Parameters

Thanks Much,

Tom
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39773
    
  28
I think this is too difficult a question for “beginning” and it would sit better in our databases forum.
Tom Piersa
Greenhorn

Joined: Sep 25, 2009
Posts: 19
Could you please move it. Not sure if I can do that.

Thanks,

Tom
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19757
    
  20

Campbell already moved it. In the original forum there is a link to the JDBC forum where the thread is now located.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server 2008 Table Valued Parameters