I have been getting my named parameter query work, but always failed.

In my Role.hbm.xml:

<query name="examples.getRolesFromIds">
<![CDATA[
from Role as r where r.id in :ids
]]>
</query>

I am using MS SQL server. I passed ('1', '3'), but the system complains
about syntax being error. What is the correct way to do named and
parameterized query for the above query.

As a general question, we know that hibernate issues SQL queries to database.
What configuration should I do in order for hibernate to display the sql qeuries it generates?

Thanks, Pete

There are two way to pass the parameters. Firstly, by index. Secondly, by name. Your using a named parameter with a name of 'ids'. So query.setInt('ids', 3); Might do the trick.

Anyway, this is documented see:
http://www.hibernate.org/hib_docs/reference/en/html/manipulatingdata.html#manipulatingdata-querying

The property is showSQL="true" which is also documented.