Here is my stored Procedure

Create PROCEDURE  [dbo].getUserAndEnum

AS

BEGIN

select * from user_master where id =1

select * from enum_master where id = 1

End

With hibernate i written

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.

Edit
Report