How to use a Named SQL query ?

Named SQL queries are defined in the mapping xml document and called wherever required.

We can use named parameters (example :name ) instead of ? with Named queries.

Define Named Query (with named parameter)

<sql-query name = "empdetails">

   <return alias="emp" class="com.genius.Employee"/>

      SELECT emp.EMP_ID AS {emp.empid},

                      emp.EMP_ADDRESS AS {emp.address},

                      emp.EMP_NAME AS {emp.name}

      FROM Employee emp

      WHERE emp.NAME LIKE :name

</sql-query>

Invoke Named Query

List people = session.getNamedQuery("empdetails")

                     .setString("name", "TomBrady")

                     .setMaxResults(50).list();