Point me to a COMPLETE HQL reference?

[Philippe Desrosiers]

Can anyone point me to a COMPLETE HQL reference guide? The Hibernate docs are a little anemic on the specification side of things. They give one or two kindergarten examples, but, for instance, leave out the LIKE operator entirely.

Failing this, can anyone tell me how to use the LIKE operator in HQL queries? Is "from MyObject where MyField like :param" equivalent to the SQL "SELECT * FROM MyTable where MyColumn LIKE '%param%'"

or LIKE '%param' ?

or LIKE 'param%' ?

The hql documentation (such as it is) is silent on the subject. Help!

[Santosh Ramachandrula]

http://www.stpe.se/2008/07/hibernate-hql-like-query-named-parameters/

[Paul Sturrock]

Like and wildcards behave exactly the same in SQL and HQL. So:

from MyObject where MyField like :param

in HQL is synonymous with:

Select * from MyTable where MyField like 'param';

in SQL.

Can't help you with a free HQL reference. The Hibernate books offer more complete examples. Its worth getting the Hibernate tools plugin for eclipse since this includes a perspective from which you can run arbitrary HQL.

[Philippe Desrosiers]

JACKPOT!

Thanks for both your responses. Very helpful!

[Pavlo Lozovskiy]

Hi,

maybe you already got the answer, but this could help the others who is looking for HQL reference, here you are --> HQL: The Hibernate Query Language

Regards,
zz_fluke