8.10. JOnAS EJBQL extension

8.10.1. LIMIT clause

The LIMIT feature has been added to the standard EJBQL query language. This feature enables you to retrieve just a portion of the results generated by the rest of a query.

The syntax of the LIMIT clause is:

limit_clause ::= LIMIT limit_expression (, limit_expression )?
limit_expression ::= integer_literal | input_parameter

The first limit_expression corresponds to the start_at range and the second one to the size range.

The limit_clause is the last clause of the query:

ejbql ::= select_clause from_clause [where_clause] [orderby_clause]
    [limit_clause]

Example:

SELECT OBJECT(c) FROM jt2_Customer AS c ORDER BY c.id LIMIT ?1, 20

NoteNote
 

This feature is currently not implemented on all the database types supported by JORM/MEDOR.