<class name="springapp.web.Event" table="EVENTS">
           <id name="id" column="EVENT_ID">
               <generator class="identity" />
           </id>
           <property name="title" type="string" column="TITLE"  not-null="true"/>
           <property name="date" type="date" column="EVENT_DATE" not-null="true"/>
           <loader query-ref="getEventSP"></loader>
     </class>
   <sql-query name="getEventSP" callable="true">
      <return alias="getEventSP" class="springapp.web.Event">
         <return-property name="id" column="EVENT_ID"></return-property>
         <return-property name="title" column="TITLE"></return-property>
         <return-property name="date" column="EVENT_DATE"></return-property>
      </return>
      { ? = call selectAllEmployments(?) }
   </sql-query>

public class Event implements Serializable{
   
   private java.lang.Integer id;
   private java.lang.String  title;
   private Date date;
   
   public Date getDate() {
      return date;
   }
   public void setDate(Date date) {
      this.date = date;
   }
   public java.lang.Integer getId() {
      return id;
   }
   public void setId(java.lang.Integer id) {
      this.id = id;
   }
   public java.lang.String getTitle() {
      return title;
   }
   public void setTitle(java.lang.String title) {
      this.title = title;
   }
}

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();
tx = session.beginTransaction();
Query query = session.getNamedQuery("getEventSP");
query.setInteger(0,1);
List<Event> books = query.list();
  for (Iterator<Event> iter = books.iterator(); iter.hasNext();) {
   Event book =  iter.next();
   System.out.println("last name===>"+book.getTitle());;
}
tx.commit();

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
   <class name="DAO.procDAO.Events">
        <id name="event_id" />
        <property name="title" />
        <property name="event_date" />
    </class>
   <sql-query name="getEventSP" callable="true">
      <return alias="events" class="DAO.procDAO.Events">
         <return-property name="event_id" column="event_id" ></return-property>
         <return-property name="title" column="title"></return-property>
         <return-property name="event_date" column="event_date"></return-property>
      </return>
      { call getEvent(:first) }
   </sql-query>
</hibernate-mapping>

package DAO.procDAO;

import java.io.Serializable;

public class Events implements Serializable {
    private Long event_id;
    private java.lang.String title;
    private java.util.Date event_date;

    public Events() {

    }

   public java.util.Date getEvent_date() {
      return event_date;
   }

   public void setEvent_date(java.util.Date event_date) {
      this.event_date = event_date;
   }

   public Long getEvent_id() {
      return event_id;
   }

   public void setEvent_id(Long event_id) {
      this.event_id = event_id;
   }

   public java.lang.String getTitle() {
      return title;
   }

   public void setTitle(java.lang.String title) {
      this.title = title;
   }

   
}

protected List getStoredProcedure(java.lang.String namedQuery,HashMap mapValue){
       startOperation();
       Query query = session.getNamedQuery(namedQuery);
       Set keySet = mapValue.keySet();
       Iterator keySetIterator = keySet.iterator();
       while(keySetIterator.hasNext()){
          Object key = keySetIterator.next();
          Object value = mapValue.get(key);
          System.out.println("key="+key+",value="+value);
          query.setParameter(key.toString(),value.toString());
       }
        tx.commit();
       return query.list();
    }