Mix HQL and Criteria API in Hibernate

Question

Is it possible to mix HQL and the Criteria API?

I have a String that contains a where condition in HQL and a Criteria that is already built and got from somewhere else. I wonder if I can add the where condition String to Criteria.add(). The where condition could be multiple conditions "and-ed"/"or-ed" together.

Can I do this without parsing the where condition String?

Answer 1

have a look at Filters

Answer 2

You can use Restriction.sqlRestriction(String sql).