Hibernate Detached Criteria

This section is good discussion about hibernate detached criteria.

Hibernate Detached Criteria

Hibernate Detached Criteria

This section is good discussion about hibernate detached criteria.

Detached Criteria in Hibernate :

Detached criteria is very good alternate when the hibernate session is not present. You can say detached criteria is a concept of writing query in detached mode.

You can instantiate this class anywhere. For this you have to import -

org.hibernate.criterion.DetachedCriteria;

Way to write DetchedCriteria -


DetachedCriteria query = DetachedCriteria.forClass(Employee.class);
query.add(Property.forName("name").eq("Som"));

Next you can obtain criteria by passing any arbitrary session to getExecutableCriteria() as -

employeeList = query.getExecutableCriteria(session).list();

Here is an example of detached criteria. Employee is our table. This example show the record of employee named "Som".

package net.roseindia.main;

import java.util.*;
import net.roseindia.table.Employee;
import net.roseindia.util.HibernateUtil;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Property;

public class DetachedCriteriaQuery {
public static void main(String[] args) {
DetachedCriteria query = DetachedCriteria.forClass(Employee.class);
query.add(Property.forName("name").eq("Som"));
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();
List<Employee> employeeList = new ArrayList<Employee>();
employeeList = query.getExecutableCriteria(session).list();
Iterator it = employeeList.iterator();
while (it.hasNext()) {
Employee employee = (Employee) it.next();
System.out.println("Name : " + employee.getName());
System.out.println("Salary : " + employee.getSalary());
System.out.println("Date of Join : " + employee.getDateOfJoin());
}
session.close();

}
}

Output :

Hibernate: select this_.emp_id as emp1_0_0_, this_.date_of_join as date2_0_0_, this_.name as name0_0_, this_.salary as salary0_0_ from employee this_ where this_.name=?
Name : Som
Salary : 20000
Date of Join : 1999-06-22 00:00:00.0

Download complete source code