Change Notes item #917228, was opened at 2004-03-16 13:03
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=381174&aid=917228&group_id=22866
Category: JBossCMP
Group: v4.0
Status: Open
Priority: 5
Submitted By: Alexey Loubyansky (loubyansky)
Assigned to: Nobody/Anonymous (nobody)
Summary: EJB QL 2.1
Initial Comment:
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.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=381174&aid=917228&group_id=22866
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
