return result;
}
@Override
public Order getOrderByLastNameAndCRN(String crn, String lastName) {
Order result;
Integer orderId = Order.crnToOrderId(crn);
if (orderId == null) {
return result = null;
}
// If problems come up again, this could help: select p FROM Person p
// left join fetch p.address
try {
result = (Order) em
.createQuery(
"SELECT o FROM Order o INNER JOIN o.customer c WHERE c.lastName = ?1 AND o.id = ?2")
.setParameter(1, lastName).setParameter(2, orderId)
.getSingleResult();
} catch (Exception e) {
result = null;
}
// LazyLoading error workaround
// result.getCustomer();
if (result != null){
result.getOrderLines().size();
}
// result.getStatus().getStatus();
return result;
}