Chapter 7. EJB-QL: The Object Query Language

Chapter 7. EJB-QL: The Object Query Language

7.1. Case Sensitivity
7.2. The from clause
7.3. Associations and joins
7.4. The select clause
7.5. Aggregate functions
7.6. Polymorphic queries
7.7. The where clause
7.8. Expressions
7.9. The order by clause
7.10. The group by clause
7.11. Subqueries
7.12. EJB-QL examples
7.13. Bulk UPDATE & DELETE Statements
7.14. Tips & Tricks

EJB3-QL has been heavily inspired by HQL, the native Hibernate Query Language. Both are therefore very close to SQL, but portable and independent of the database schema. People familiar with HQL shouldn't have any problem using EJB-QL. Actually, you use the same query API for EJB-QL and HQL queries. Portable EJB3 applications however should stick to EJB-QL or similar vendor extensions are needed.