Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Object Relational Mapping
Stored Procedures that return multiple result sets using Hibernate
posted 2 years ago
Does Hibernate have the ability to return multiple result sets from a Stored Procedure call?
Like this SP from MS SQL
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE DBO.FIND_MULTI_RESULT_SETS @Table_ID tinyint AS BEGIN SET NOCOUNT ON; SELECT * from Table_1 where Table_1.ID = @Table_ID; SELECT * from Table_2 where Table_2.ID = @Table_ID; END GO
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
Boost this thread!
Comparing 2 tables
how to access MSAccess and Oracle in one query
why we require execute() method?
HIBERNATE- one-to-many mapping with different field names