Table Valued Parameter (TVP) in Jdbc Java

Exam Date-sheet 2015 for all courses of CCS University, Meerut | Create a WCF project and host it in IIS without using a .svc file

Table Valued Parameter (TVP) in Jdbc Java

6. January 2015 Anil Kumar MS-SQL Comments (0)

It seems Jdbc driver doesn't have any direct support for TVP even in its latest version. Refer:

http://blogs.msdn.com/b/jdbcteam/archive/2012/04/03/how-would-you-use-table-valued-parameters-tvp.aspx?PageIndex=2#comments

TVP comes with great features & benefits which superced its all previous colleagues of parameter types. Refer: http://msdn.microsoft.com/en-us/library/bb510489.aspx#Benefits

TVP has been widely covered by Microsoft SQL Server MVP Erland in his post here : http://www.sommarskog.se/arrays-in-sql-2008.html

In this post he coveres "Using Table-Valued Parameters from Other APIs" which is read worthy.

However TVP can be used at MS SQL Server and implemented in Java using Jdbc Array OR using third party dll/frameworks, which is precisely not suggested over old fashion i.e. XML parameter type.

@AnilAwadh

jQuery export table data into MS ExcelWe can use window.open() to export table data into Excel or any required format. It is the easiest a...Important Oracle Error CodesHere let us see some important Oracle error codes - 1) ORA-00001: unique constraint (constraint_nameDelete all empty or blank rows from DataTableDelete all empty or blank rows from DataTable in vb.net (none of columns of that row holds any value...

CodePattern.net

Learn Agile/Scrum, Project Management, Career Advice, C#, WCF, Web API, .net, jQuery, SQL

Table Valued Parameter (TVP) in Jdbc Java

Related posts