How to put a comment into HQL (Hibernate Query Language)?
Is it possible to put comments into Hibernate Query Language? If so, how?
AFAIK, HQL does not support comments.
Make sure your session is configured with:
Query query = ...; query.setComment("Some comment here");
and you will see something like the following in your MySQL log file (if you're using MySQL):
5998 Query /* Some comment here */ select .....
If it helps your development, Hibernate Tools (Eclipse) supports double hyphens as single-line comments in their HQL editor. Helps me a lot. I've just tried the JPQL statement
SELECT pro --ro.id, cl.name, te.ordinalNbr, tt.code, se.startYear, pro.id, pcl.name, pte.ordinalNbr, ptt.code, pse.startYear FROM Roster ro JOIN ro.season se JOIN ro.team te JOIN te.club cl JOIN te.teamType tt JOIN te.rosters pro JOIN pro.season pse JOIN pro.team pte JOIN pte.club pcl JOIN pte.teamType ptt WHERE ro.id = 32 ORDER BY pse.startYear
and it returned the pro instances.
Also not quite to the point, but it might be useful nontheless.