Hello,

I want to pass a table or two integer arrays(any of these two options as long as it works) to a stored procedure. I have a POJO with this structure:
int id;
int order;
and I want to send a list of these kind of objects, so practically, a table with two int columns (id, order).

From what I found on the internet until now, there is a possibility using a data table type in SQL. I already created one with:
CREATE TYPE [dbo].[WebSortOrderTable] AS TABLE(
[id] [int] NOT NULL,
[web_sort_order] [int] NULL
)

The problem that I have is that I don't know how to pass the input to the stored procedure with hibernate.

The stored procedure looks like this:
CREATE procedure [dbo].[spwebSortOrderUpdate]
(@webSortOrderArray dbo.WebSortOrderTable READONLY)
AS
BEGIN
UPDATE dbo.Ch_Profiles_complex_items
SET Ch_Profiles_complex_items.web_sort_order = array.web_sort_order
FROM dbo.Ch_Profiles_complex_items INNER JOIN
@webSortOrderArray AS array ON array.id = Ch_Profiles_complex_items.row_id
END

Thank you in advance!

I'm not sure if you can do it with the Hibernate specific API, but you can always get access to the underlying JDBC Connection as follows: