Hibernate query on string list in entity

Question

Consider an entity

@Entity
class Book{
  ...
  @ElementCollection(fetch = FetchType.EAGER)
  List<String> tags = new ArrayList<String>();
  ...
}

What should be the hibernate query so one can get all the books containing any multiple tag "hobbit,sherlock,fiction"(OR operation splitted by comma).Any query(HQL,Criteria or raw SQL) will work,though Criteria is prefered.

Gufran Khurshid · Accepted Answer · 2015-10-19 11:06:26Z

2

I solved the problem by myself but not using pure criteria

criteria.add(Restrictions.sqlRestriction("BOOK_ID IN " +
            "(SELECT BOOK_ID FROM Book_tags " + 
            "WHERE tags ='" + tag + "')"));

Please note the single quote surrounding the query parameter 'tag' .Pure criteria query is always welcomed.

answered Oct 19, 2015 at 11:06

Gufran Khurshid

9492 gold badges9 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Hibernate query on string list in entity

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