File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server 2008 Table Valued Parameters

 
Tom Piersa
Greenhorn
Posts: 19
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 47222
52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think this is too difficult a question for “beginning” and it would sit better in our databases forum.
 
Tom Piersa
Greenhorn
Posts: 19
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you please move it. Not sure if I can do that.

Thanks,

Tom
 
Rob Spoor
Sheriff
Pie
Posts: 20368
43
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Campbell already moved it. In the original forum there is a link to the JDBC forum where the thread is now located.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic