I am trying to perform a database sort by using "order-by" option within a many-to-many relationship. The order-by option however requires the name of a column within the link table and I need to sort on a column that is a child of the link table. For example the following designates the sort order to be done on categories.name however I receive the message "column not found" because it is trying to find it in the HEADINGCATEGORY table.

<set name="categories" table="HEADINGCATEGORY" cascade="none" order-by="categories.name asc" lazy="false" >
<key column="HEADING_ID" />
<many-to-many column="category_id" class="Category" />
</set>

Any thoughts would be appreciated.

Hi,

Have you resolved this problem ?

I have used order-by attribute and I used to give the native SQL column name in the order-by attribute. I am not sure, whether there is a support if we give the hibernate property name. However I never have tried so.

I guess, you are specifying the property name for order-by attribute whereas the error message is 'Column not found' which looks to me like, the order-by attribute looks for a native sql column name.

If it looks for the hibernate property, the error message would be something like 'Could not resolve property', correct me if I am wrong.

Thanks,
Senthilkumar Arumugam

Hi,

Senthilkumar is right. Take a look at this doc:

http://docs.jboss.org/hibernate/core/3. ... ons-sorted

thanks for the response!

The problem is that it is a many-to-many relationship and a connecting table exists. The Group-by clause has access to this connecting table and not to the table that I want to sort on. The connecting table consists of two columns, a key to each of the tables we are connecting. The field we want to sort on is in the table we are connecting to. For example we have access to many-to-many connecting table "headingcategory". This table contains a key to heading table and a key to category table. I want to sort on column "name" in the category table. There would not be problem if we wanted to sort on a column in "headingcategory" table however we want to sort on a column in the category table. How can hibernate obtain access to the column name in the category table?