[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - ManyToMany, sort by field in mapping table

Dear colleagues, I have Termnal and Firmware entities , with Terminal_Firmware table that defines many-to-many relationship. Terminal has a collection of bound Firmwares : @ManyToMany(cascade = {CascadeType.PERSIST}) | @JoinTable( | name="Terminal_Firmware", | joinColumns=@JoinColumn(name="tId", referencedColumnName="tId"), | inverseJoinColumns=@JoinColumn(name="fId", referencedColumnName="Id") | ) | | public List<Firmware> getFirmwares() | { | return firmwares; | } Terminal_Firmware also contains integer column "position", which I want firmwares to be sorted by. Problem can be solved by adding a separate entity for Terminal_Firmware and making a query to all 3 tables, but I'd like to avoid that . @OrderBy annotation does not work for fields in mapping table. Do you know the way ? Many thanks in advance. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4115412#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...