Example queries
"Version properties, identifiers and associations are ignored."

What is than the best way to search by example when you have associations?

For example: we have class Book which holds many-to-one Author object

public class Book {

private int m_book_id;
private String m_title;
private Author m_author;
...

public Author getAuthor() {
return m_author;
}

public void setAuthor(Author author) {
m_author = author;
}

...
}

So if I would like to find all Books written by exact Author, what should I do, so that I don't have to write HQL?


Author author = ... load / get exact Author
Book book - new Book();
book.setAuthor(author);
Example example = Example.create(book);
List list = session.createCriteria(Book.class).add(example).list(); //#1

OK, as written "associations are ignored", so #1 wouldn't include author field in query, and I would get all books.

Is this the best solution:
List list = session.createCriteria(Book.class).add(Expression.eq("author", author)).list(); //#2

What is the reason #1 isn't implemented?

Thnx, Ales

I had the same problem, sort of frustrating

I don't know the reason #1 isn't implemented, but I made a change to Example.java (hibernate2 src) to make it work. I don't think Gavin wants associations to be considered in query by example.

Gavin's response:
http://forum.hibernate.org/viewtopic.ph ... highlight=

To toastchee:

Did you fix the Example source or did you extend it?
Can you please send me this fixed version.

Thanx,
Ales

I fixed the source, but my patch was rejected by Gavin. Would you mind contacting Gavin and asking him to reconsider? :-)