Hello All,
My question is how to use a stored procedure of multiple queries with criteria or hibernate & get multiple results accordingly?
Here is my stored Procedure
Code:
Create PROCEDURE [dbo].getUserAndEnum
AS
BEGIN
select * from user_master where id =1
select * from enum_master where id = 1
End
With hibernate I have written
Code:
Session session = HibernateFactory.getSessionFactory().openSession();
Transaction tr = session.beginTransaction();
SQLQuery qr=session.createSQLQuery("getUserAndEnum");
List list = qr.list();
In list I am getting only the user object ..what about my enum_master row with id 1
P.S enum_master row with id 1 is there in DB
Thanks.
Login
FAQ
Search