wood burning stoves 2.0*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 36478
    
  16
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: 19541
    
  16

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
 
Similar Threads
"Recordsets" in Java Applets
MS SQL SERVER StTORED PROCEDURE
Stored procedure call removes spaces in text
Problem using Callable Statement
JDBC Stored Procs and Temp tables