my sql should look like this:
select cell1 from table
where cell2 = 1
and (cell3 = '' or cell3 is null)
But how to do the "and ( x or y )" restricion with hibernate?
What about LogicalExpression
Try this for AND condition:
Criteria cr = session.createCriteria(table.class);
// To get records matching with AND condistions
LogicalExpression andExp = Restrictions.and(cell2, cell3);
cr.add( andExp );
For OR condition use this
// To get records matching with OR condistions
LogicalExpression orExp = Restrictions.or(cell2, cell3);
cr.add( orExp );
List results = cr.list();