2.10.2.5.4. JPQL Input Parameters

Either positional or named parameters may be used. Positional and named parameters may not be mixed in a single query.

Input parameters can only be used in the WHERE clause or HAVING clause of a query.

Note that if an input parameter value is null, comparison operations or arithmetic operations involving the input parameter will return an unknown value. See JPQL Null Values.

All input parameters must be single-valued, except in IN expressions (see JPQL In Expressions ), which support the use of collection-valued input parameters.