Left connection using sleep criteria

Question

I have two objects: Issue and Issue_Tracker . I am using Hibernate 3.6.

 SELECT `issues`.`issue_id`, `issues`.`issue_raised_date`, `issues`.`issue_description`, `issue_tracker`.`tracker_status` FROM `issues` LEFT JOIN `issue_tracker` ON `issues`.`issue_id` = `issue_tracker`.`issue_id` WHERE `issues`.`status`="Escalate To" 

How to achieve this with Hibernate Criteria, and most importantly, I have to use it for pagination.

, and My Dao is as follows to display a list of problems in jqgrid

public List showHelpDeskIssues (DetachedCriteria dc, int from, int size) {

 Session session = HibernateUtil.getSessionFactory().getCurrentSession(); try { Criteria criteria = dc.getExecutableCriteria(session); criteria.setFirstResult(from); criteria.setMaxResults(size); criteria.add(Restrictions.eq("status","Escalate To")); return criteria.list(); } catch (HibernateException e) { e.printStackTrace(); throw e; } } 

For a brief explanation, please refer to this question how to show two data tables in jqgrid using struts2 - jqgrid plugin and hibernate any help would be great.

Answer 1

you can try the following

 Criteria criteria = session.createCriteria(Issues.class); criteria.setFirstResult(from); criteria.setMaxResults(size); criteria.setFetchMode('parent.child', FetchMode.JOIN); criteria.add(Restrictions.eq("status", "Escalate To"); List<Issues> list= criteria.list(); 

here parent is the name of the property in Issues.java , and child is the property in IssueTracker.java .

Answer 2

Well,

follow one example ...

 Criteria crit = session.createCriteria(Issues.class); crit.createAlias("otherClass", "otherClass"); crit.add(Restrictions.eq("otherClass.status", "Escalate To")); List result = crit.list(); 

I think this may help !!

Answer 3

Try it because it worked for me

 Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Issues.class, "issues"); criteria.setFetchMode("issues.issuetracker", FetchMode.JOIN); criteria.createAlias("issues.issuetracker", "issuetracker"); criteria.add(Restrictions.eq("status","Escalate To")); List list = criteria.list(); return list;