Hi,

I'm using hibernate 2.1.7 and i've got some problems ordering a table.
This is my mapping:

<class name="User" table="users">
<id name="id" column="usr_userid" type="int" unsaved-value="null">
<generator class="assigned" />
</id>
<property name="language" column="usrlan" type="string" />
...
<many-to-one name="client" column="usr_idclie"
class="Client" cascade="none" update="false"
insert="false"/>
</class>

I need to get all users, ordered by fullName, which is a Client field

So, i do :

session.query (" from User user order by user.client.fullName desc ");

But my problem is :

it doesn't return all the rows, only those whose client field (usr_idclie) is filled, but i need all the users, what i'm doing wrong ? May be is bad - mapped ?

Can anybody help me please?

Thanks for advanced.

I did another test

I tried to get All users ordered by id (it's the key) instead of fullName.

session.query (" from User user order by user.client.id desc ");

and i got all the entries, it means, users with client and users without client, well-ordered by id.

However, if i do the same, ordered by another field, for example, fullName,
it doesn't work succesfully. It retrieves only the users with client. not ALL.


Please, can any body help me ? or suggest me any idea?

Thanks.

Hi Salino
You can try giving OrderBy in the mapping where you defined.
OrderBy column name , Asc/Desc

just check out the syntax i dont remember

Thanks