[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: JBoss 4.0.2, EJB QL and Left join problem

[Holy Joe]

I have no idea if this will work, or even if it's legal HQL, but the first thing I would try is


  | SELECT OBJECT(o) FROM ChargingPoint AS o, IN(o.history) AS h RIGHT JOIN SubNetwork n
  |   WHERE h.isActive = true
  |   AND h.beginDate <= ?2 AND (h.endDate IS NULL OR h.endDate > ?2)
  |   AND (h.downstreamSubNetwork = n OR h.upstreamSubNetwork = n)
  |   AND (n = ?1)
  |   ORDER BY o.identifier	
  | 


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3966803#3966803

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3966803