Named query-use and

Question

I have read Named query. We can use < query> and < sql-query> in mapping file for named query. I cant understand the difference between < query> tag and < sql-query> tag. When we have to use < query> tag and when we have to use < sql-query> tag.

e.g.

<query name="findOneEmp">
    <![CDATA[from Employee e where e.empId= :empID]]>
</query>

and

<sql-query name="findEmpNativeSQL">
   <return alias="employee" class="com.common.Employee"/>
   <![CDATA[select * from employee e where e.empId = :empID]]>
</sql-query>

query mean hql and sql query means native sql :) – Mahdi Shabani Oct 15 '13 at 13:07 — Mahdi Shabani, Oct 15 '13 at 13:07

score 1 · Accepted Answer · answered Oct 15 '13 at 20:18

1

Query tag are meant for HQL queries, and Sql-query is meant for declaring the native sql queries.

answered Oct 15 '13 at 20:18

Zeus

6,386
6
54
89

Named query-use and

1 Answers1