Hello. I have a class called System which contains a collection of Modules. I use a bag, like this:

@hibernate.bag table="system_module" cascade="save-update" lazy="true" order-by="description"
@hibernate.collection-many-to-many class="Module" column="id_module"

I would like to order the collection by the description fileld of Module but the above line is giving an error:

Unknown column 'modules0_.description' in 'order clause'

I guess because there is no description field in system_module. How can I do this with xdoclet / hibernate mapping file?

Thanks in advance!

Bob

So, do you have a "description" field in your database table or not?