Hi,

Named SQL queries may be defined in the mapping document ? In which document it should be defined , can I have an example?.

Name Query is define in in hbm file.eg i have a Cat.hbm.xml file where i define a named query as

<query name="findCatsByPerson"><![CDATA[
from Cat c where c.person.id = :id2Find
]]></query>

outside the the <class> tag.

for detailed information read Hibernate in Action chapter 7.

[if it helped u plz rate it].