About Question enthuware.oce-jpad.v6.2.463 :
Posted: Wed May 23, 2012 1:53 am
Though not the subject of the question, but won't this return multiple results if the customer has multiple orders ?! You know we should have used distinct c.
Java Certification Resources and Java Discussion Forum
http://www.enthuware.com/forum/
I tried to return a list of result and a single result. Both work. I don't know why. Maybe, it is specific to Hibernate.Though not the subject of the question, but won't this return multiple results if the customer has multiple orders ?! You know we should have used distinct c.
Code: Select all
List cos= new ArrayList();
String qr = "SELECT co FROM CustOrder co join co.lineItems li WHERE co.id = 79";
Query query = em.createQuery(qr);
cos = query.getResultList();
for(Object obj : cos) {
CustOrder co= (CustOrder) obj;
System.out.println(co);
}
//output:
salesapp.CustOrder[id=79 customer =Not Loaded items = Not Loaded]
salesapp.CustOrder[id=79 customer =Not Loaded items = Not Loaded]
salesapp.CustOrder[id=79 customer =Not Loaded items = Not Loaded]
salesapp.CustOrder[id=79 customer =Not Loaded items = Not Loaded]
salesapp.CustOrder[id=79 customer =Not Loaded items = Not Loaded]
Code: Select all
CustOrder co= null;
String qr = "SELECT co FROM CustOrder co join co.lineItems li WHERE co.id = 79";
Query query = em.createQuery(qr);
co = query.getSingleResult();
System.out.println(co);
//output:
salesapp.CustOrder[id=79 customer =Not Loaded items = Not Loaded]