-
I believe hibernate first translates your HQL query to SQL and only after that it tries to bind your parameters. Which means that it won’t be able to rewrite query from
param = ?
toparam is null
. -
Try using Criteria api:
Criteria c = session.createCriteria(CountryDTO.class); c.add(Restrictions.eq("type", type)); c.add(status == null ? Restrictions.isNull("status") : Restrictions.eq("status", status)); List result = c.list();