Hibernate Community • View topic - Collections Order by associated table column

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Collections Order by associated table column

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

deepannair

Post subject: Collections Order by associated table column

Posted: Fri Oct 10, 2008 1:27 pm

Newbie

Joined: Fri Oct 10, 2008 1:15 pm
Posts: 1

Hibernate 3.2
I have 2 tables which have a many-many relation via a mapping table. I need to sort the collection based on the column ina ssociated table. I have read that hibernate Orderby does not support that. What could be a workaround?

Tables - BM->BM_REPORT ->Report
BM Report is my mapping table. I need to sort by the Report_ID column in Report table

Code:

My mapping in main entity(BM

@Entity
@Table(name = "BM")
public class BM implements Serializable  {
  
   private Set<BaseModelReport> reports = null;
  
   @org.hibernate.annotations.CollectionOfElements
    @JoinTable(name = "BM_REPORT",  joinColumns = @JoinColumn  (name    = "BM_ID) 
   public Set<BMeport> getReports() {
      return reports;
   }
}

Thanks,
DN

Top

Page 1 of 1

[ 1 post ]

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