Hibernate 2.1.1

Hi all,

This is the mapping :

<hibernate-mapping>
<class name="be.asp.pktr.bean.UserrightsBEAN" table="pktr_userrights">

<composite-id>
<key-property name="acco_id" column="acco_id" type="integer"/>
<key-property name="user_id" column="user_id" type="integer"/>
<key-property name="appl_id" column="appl_id" type="integer"/>
</composite-id>

<property name="userr_actif" column="userr_actif" type="integer" />
<property name="userr_authorized" column="userr_authorized" type="integer" />
<property name="userr_admin" column="userr_admin" type="integer" />
<property name="userr_creationTMS" column="userr_creationTMS"/>

<many-to-one name="account" class="be.asp.pktr.bean.AccountBEAN" column="acco_id" insert="false" update="false" />
<many-to-one name="user" class="be.asp.pktr.bean.UserBEAN" column="user_id" insert="false" update="false" />
<many-to-one name="application" class="be.asp.pktr.bean.ApplicationBEAN" column="appl_id" insert="false" update="false" />

</class>
</hibernate-mapping>


This one works :
query = session.createQuery(
"select a from UserrightsBEAN as a " +
"left join a.user b " +
"left join a.account c " +
"left join a.application d " +
"where (a.acco_id = :p1) " +
"order by b.user_login ");
query.setParameter("p1", acco_id);

This one doesn't works :

query = session.createQuery(
"select a from UserrightsBEAN as a " +
"left join a.user b " +
"left join a.account c " +
"left join a.application d " +
"where (a.acco_id = :p1) " +
"order by :p2 ");
query.setParameter("p1", acco_id);
query.setParameter("p2", order);

with String order := "b.user_login"

No error , but also not ordered


any idea or any other solution ???


Tnx in advance!

order by :p2
cannot bind parameter for order clause, i think it's not possible to do