Hi,

Is there any way by which I can identify, whether the named query I get is an HQLQuery or a native SQL query?

Regards,
Sandeep

My requirements is -
if i have an <query>, i use filter..
and since <sql-query> doesn't support filter, I have to append an AND clause to my SQL query..

so based on whether it is a HQL or SQL query, i have to make changes but am unable identify the type..

Any suggestions?

You shouldn't add anything to a native SQL, filters are not supported because that breaks so easily.
Better to declare an additional query having the filter already.

Have solved it as follows -

query = session.getNamedQuery(queryId);

if(query.getClass().getSimpleName().equals("SQLQueryImpl")){
//process for SQL
} else
//process for HQL

still, I don't think you should change a NamedQuery after it's defined.

hi sanne,

Thanks for the response. I understand it's not advisable to edit your named query. :(
But my requirement is a bit strange, which is described here -

https://forum.hibernate.org/viewtopic.php?f=1&t=1008837