EJB 2.1 Aussichten Persistenz

• ORDER BY

  SELECT OBJECT(c) FROM Person p, IN(p.contacts) c WHERE p.name = ‘kieninger' ORDER BY c.town
  
  

• Aggregate Operators

  • avg, count, max, min, sum
    SELECT AVG(p.assessment) FROM EVENT e, IN(e.participations) p WHERE e.place = 'Mannheim‘
    

• null value handling (und anderes bei queries) geklärt

  SELECT c.phone FROM Person p, IN(p.contacts) c WHERE p.user.name = %1 AND c.email IS NOT NULL