Hii, I am using Hibernate 4.3 version. I need to write restriction on a particular column(which is Many to one Mapped) if that particular column is not null, I am unable to write this condition in the criteria query. Thanks.

Hii Thanks for your support. I resolve my issue. the code is like this: Criterion allergen1Condition1=Restrictions.ne("allergen1",staticAppDataDao.getAllergenById(Integer.valueOf(allergenList[i]))); Criterion allergen1Condition2=Restrictions.isNull("allergen1"); LogicalExpression allergen1Condit…

Write not equal Restriction with Hibernate Criteria if the particular column is not null

Hibernate ORM

vlad May 4, 2018, 4:20am 6

First, you need to add the SQL statement you want to be generated.

Topic		Replies	Views
New Hibernate how to do a "Or" condition Hibernate ORM	1	433	September 25, 2018
HQL query select one set of columns vs select other columns when a particular column is null Hibernate ORM	14	9222	October 24, 2018
NPE with empty predicate list (criteria api) Hibernate ORM	1	1138	December 13, 2022
Criteria API query involving collection AttributeConverter stopped working in Hibernate ORM 6.3 Hibernate ORM	2	623	November 6, 2023
Define JPA relation with condition on another relation Hibernate ORM	4	796	May 27, 2025

Write not equal Restriction with Hibernate Criteria if the particular column is not null

Related topics