Hibernate Community • View topic - How to define order-by column in a many-to-many relationship

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to define order-by column in a many-to-many relationship

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

nwbr

Post subject: How to define order-by column in a many-to-many relationship

Posted: Sun Nov 13, 2005 4:50 pm

Newbie

Joined: Sun Nov 13, 2005 12:31 pm
Posts: 3

I have:

<set name="itens" cascade="all" table='"SIM_PROJECTITEM"'>
<key column="fkproject"/>
<many-to-many column="fktreenode" class="br.com.simageWeb.models.TreeNode"/>
</set>

in my project mapping file and I want to recover my itens order by its names. If I add

order-by="name asc" in the <set> I got a error that says

"Caused by: org.postgresql.util.PSQLException: ERROR: column itens0_.name does not exist".

I think that the Hibernate is searching for name in the intermediate table. So, what is wrong?

Top

iphan

Post subject:

Posted: Tue Dec 20, 2005 10:24 am

Newbie

Joined: Tue Dec 16, 2003 12:02 pm
Posts: 14
Location: Geneva, Switzerland

AFAIK, you cannot define an order-by in your example.
However you could use HQL to order your collection in the application using something like:

Code:

List myOrderedCollection = session.createFilter(myObject.getItems(), "order by this.name")
                                             .list();

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum