I have a calendar object that have holidays (a map) which is a mapping of hol_name and hol_date. A map from string indices to dates:

<map name="holidays" table="holidays">
<key column="id"/>
<index column="hol_name" type="string"/>
<element column="hol_date" type="date"/>
</map>


What does the HQL named query look like if I need to make a query which uses holiday name as an input variable parameter (:hol_name) and gets queried result as the corresponding date for the holiday?

What does the HQL named query look like if I need to make a query to get the holidays (a map) only, instead of the calendar object.

Thanks.