Dear all,
I'll be thankful to you if you can save me from this problem. 1st of all I'm a very beginner in Hibernate and JPA.
I've 3 tables A, B and C. A has columns a1 (primary key),a2 and a3. B has b1, b2, b3, a1 and c1. C has also the same. Table A has one to many relationship to B and it is mapped by 'a1'. B has relation to C and is mapped by c1. a1 and c1 are foreign keys in B. Finally I want to create a list of 'c2'.
I got the list in the order of the contents that are in the table itself. Is there any way to sort the list using any other columns in all the tables? Also it should be using an annotation at the time of one to many declaration. Pls do the needful.


Pls reply a solution as early as possible...

Thanx.

Hibernate has two custom annotations that you can use for sorting: @OrderBy and @Sort. With @OrderBy the collection is sorted in the database and with @Sort it is sorted in memory. See http://docs.jboss.org/hibernate/stable/ ... collection for more information.