Hibernate - Interview Questions and Answers for 'Criteria' | Search Interview Question

Hibernate - Interview Questions and Answers for 'Criteria' - 6 question(s) found - Order By Rating

Q1. How to specify the or/and combination restrictions within Criteria in Hibernate ?

Ans. session.createCriteria(Employee.class).add( Restrictions.or(Restrictions.like("name", "A%"),Restrictions.like("name", "B%"))).list();

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate Criteria Restrictions}

Q2. What is Criteria in Hibernate ?

Hibernate

Ans. Criteria is a simplified API for retrieving entities by composing Criterion objects.

For example - session.createCriteria(Employee.class).add( Restrictions.like("name", "A%") ).list();

will return all employee objects having name starting with A.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate hibernate criteria Asked in 7 Companies Basic Frequent}

Try 1 Question(s) Test

Q3. How do we specify the criteria if it involves mapping between two entities or join between tables ?

Hibernate

Ans. The following code returns the list of Employee objects having employee name starting with A and Dept Name ( Department , Employee Mapped ).

session.createCriteria(Employee.class,"emp")
.createAlias("emp.department", "dept",Criteria.INNER_JOIN)
.add( Restrictions.like("name", "A%") )
.add(Restrictions.eq("dept.name","Finance")
.list();

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate hibernate criteria hibernate table mapping}

Q4. Name few Restriction Methods ?

Hibernate

Ans. eq, ge, gt , between, in , isNull, isEmpty, isNotnull, ne , like, lt , or , not

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate hibernate criteria hibernate restriction}

Q5. In Hibernate, While defining Criteria, Have you ever faced any problem while adding restrictions with user defined types or Enums ?

Hibernate

Ans. Yes, with Enum as was getting an exception while doing equality check for enum field.

got it fixed by adding @Enumerated(EnumType.STRING) to the field in entity.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate hibernate criteria enumerations}

Q6. What is your choice while writing queries within Hibernate - criteria or HQL ?

Hibernate

Ans. I prefer using Criteria for Dynamic queries and HQL for static queries.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate hibernate criteria hql}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.