EJB Query language

An EJB query is a string that contains the following elements:

• a SELECT clause that specifies the EJBs or values to return. For more information, see SELECT clause.
• a FROM clause that names the bean collections. For more information, see FROM clause.
• an optional WHERE clause that contains search predicates over the collections. For more information, see WHERE clause.
• an optional GROUP BY and HAVING clause. For more information, see Aggregation functions.
• an optional ORDER BY clause that specifies the ordering of the result collection. For more information, see ORDER BY clause.

The SELECT clause is optional in order to maintain compatibility with WAS Version 4.

Collections of entity beans are identified in EJB queries through the use of their abstract schema name in the query FROM clause.

The elements of EJB query language are discussed in more detail in the following topics:

• Example: EJB queries
• Inheritance in EJB query
• Path expressions
• Subqueries
• EJB query restrictions
• EJB Query: Reserved words
• EJB query: BNF syntax