I have got two entities Person and Book. Only one instance of a specific book is stored to
the system (When a book is added, application checks if that book is already found before adding a new row to
the database). Relevant source code of
the entities is can be found below:
@Entity
@Table(name="persons")
@SequenceGenerator(name="id_sequence", sequenceName="hibernate_sequence")
public class Person extends BaseModel
{
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "id_sequence")
private Long id = null;
@ManyToMany(targetEntity=Book.class)
@JoinTable(name="persons_books", joinColumns = @JoinColumn( name="person_id"), inverseJoinColumns = @JoinColumn( name="book_id"))
private List<Book> ownedBooks = new ArrayList<Book>();
}
@Entity
@Table(name="books")
@SequenceGenerator(name="id_sequence", sequenceName="hibernate_sequence")
public class Book extends BaseModel
{
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "id_sequence")
private Long id = null;
@Column(name="name")
private String name = null;
}
My problem is that I want to find persons, which are owning some of
the books owned by a specific persons.
The returned list of persons should be ordered by using following logic:
The person owning most of
the same books should be at
the first of
the list, second person of
the the list does not own as many books as
the first person, but more than
the third person.
The code of
the method performing this query is added below:
@Override
public List<Person> searchPersonsWithSimilarBooks(Long[] bookIds) {
Criteria similarPersonCriteria = this.getSession().createCriteria(Person.class);
similarPersonCriteria.add(Restrictions.in("ownedBooks.id", bookIds));
//How to set
the ordering?
similarPersonCriteria.addOrder(null);
return similarPersonCriteria.list();
}
My question is that can this be done by using Hibernate? And if so, how it can be done? I know I could implement a Comparator, but I would prefer using Hibernate to solve this problem.
