Hibernate criteria filter by foreign key

Question

I have two tables: authors and books. Authors has two colums: int id, varchar authorName. Books has three colums: int id, varchar bookName, int authorId.

Now considering that I take the authorName as an input String filtering criteria how can I make hibernate only return the books by that certain author?

You mention sorting. Sorting means putting a number of items in a particular order. Do you actually want to sort anything here, or do you just want to filter by the name? — Tom Anderson
– Tom Anderson, Commented Aug 5, 2013 at 8:44

Wirus · Accepted Answer · 2013-08-05 09:10:00Z

7

How about

Criteria criteria = session.createCriteria( Book.class );
criteria.createCriteria( "author", "a");
criteria.add( Restrictions.eq( "a.authorName", "YOUR_INPUT"));
criteria.list();

answered Aug 5, 2013 at 9:10

Wirus

1,19010 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate criteria filter by foreign key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related