comments in named queries?

nathanmoon · **Posted:** Thu Jun 09, 2005 1:52 pm

Hibernate version:3.0.5

Does Hibernate support SQL comments in named queries? I tried to include comments using '--', and the parser doesn't seem to like it. I got QuerySyntaxError: unexpected token.

Is there any other way to inlude a comment inline with my HQL queries?

Thanks in advance.

nathanmoon · **Posted:** Fri Jun 10, 2005 3:59 pm

I was hoping to get an answer on this, even if it's a 'not implemented - contributions are welcome'. I am externalizing some queries that were in java code and had comments from the query creators, and I'd like to preserve those comments. Essentially I'd like to be able to do something like this:

Code:

<query name="mytable.byothercolumn">
<![CDATA[
from MyTable as mytable
where mytable.SomeColumn = :val
        -- HERE I WOULD LIKE TO ADD A COMMENT
   and mytable.OtherColumn = :otherval
]]>
</query>

I just want to make sure that this is indeed NOT implemented, and I am not just overlooking something. Thanks.

max · **Posted:** Fri Jun 10, 2005 5:19 pm

that is a sql query not a hql query. use <sql-query> and it should work.

nathanmoon · **Posted:** Fri Jun 10, 2005 5:34 pm

I just made up that example query, but it was meant to be an HQL query.

What I'm asking is: does HQL support comments in any form?

max · **Posted:** Fri Jun 10, 2005 5:38 pm

no - only via query.setComment()