title: Unable to get multiple Table entities through Stored procedure using hibernate
body: <p>Here is my stored Procedure </p>
  
  <pre><code>Create PROCEDURE  [dbo].getUserAndEnum
  
  AS
  
  BEGIN
  
  select * from user_master where id =1
  
  select * from enum_master where id = 1
  
  End
  </code></pre>
  
  <p>With hibernate i written </p>
  
  <pre><code>Session session = HibernateFactory.getSessionFactory().openSession();
  
  Transaction tr = session.beginTransaction();
  
  SQLQuery qr=session.createSQLQuery("getUserAndEnum");
  
  List list = qr.list();
  </code></pre>
  
  <p>In list i am getting only  the  user object ..what about my enum_master  row with id 1 </p>
  
  <p>P.S  enum_master row with id 1 is there in DB </p>
  
  <p>Thanks.</p>