#278 EJB QL 2.1

v4.0
open
nobody
JBossCMP (36)
5
2004-03-16
2004-03-16
No

EJB QL 2.1 support is added to JBoss-4.0.0DR3.

New in EJB QL 2.1 (comparing to EJB QL 2.0):

* ORDER BY clause
EJB QL ::= select_clause from_clause [where_clause]
[orderby_clause]

* IN expression
cmp_path_expression [NOT] IN ( {literal |
input_parameter} [, {literal | input_parameter}]* )

The cmp_path_expression can now have a numeric value in
addition to string. Parameters can now appear in the IN
clause.

* LIKE expression
cmp_path_expression [NOT] LIKE pattern_value [ESCAPE
escape_character]

The pattern_value can now be a string valued input
parameter. The escape_character can now be a
character-valued input parameter.

* Null Comparison Expression
{single_valued_path_expression | input_parameter } IS
[NOT ] NULL

Can now check the input parameter for NULL value.

* Functional Expressions

Added arithmetic function MOD(int, int) returns int.

* Aggregate Functions In Select Expression
select_clause ::=SELECT [DISTINCT ] {select_expression
|OBJECT (identification_variable)}
select_expression ::= single_valued_path_expression |
aggregate_select_expression
aggregate_select_expression ::=
{AVG |MAX |MIN |SUM |COUNT }( [DISTINCT ]
cmp_path_expression) |
COUNT ( [DISTINCT ] identification_variable |
single_valued_cmr_path_expression)

JBossQL also supports EJB QL 2.1.

Discussion