user manual

182 BES Developer’s Guide
Support for ORDER BY
Support for ORDER BY
The EJB 2.0 Specification supports three SQL clauses in EJB-QL: SELECT, FROM,
and WHERE.
The Borland CMP engine also supports the SQL clause ORDER BY in the same
EJB-QL statement, provided it is placed after the WHERE clause. This is done in
the standard ejb-jar.xml deployment descriptor in the <ejb-ql> entity. For
example, the following EJB-QL statement selects distinct objects from a
Customer Bean and orders them by the LNAME field:
<query>
<description></description>
COUNT java.lang.Short java.lang.Long
MIN, MAX, SUM java.lang.Short java.lang.Short
AVG java.lang.Short java.lang.Double
COUNT java.lang.Short java.lang.Long
MIN, MAX, SUM java.lang.Double java.lang.Double
AVG java.lang.Double java.lang.Double
COUNT java.lang.Double java.lang.Long
MIN, MAX, SUM java.lang.Double java.lang.Double
AVG java.lang.Double java.lang.Double
COUNT java.lang.Double java.lang.Long
MIN, MAX, SUM java.lang.Float java.lang.Float
AVG java.lang.Float java.lang.Double
COUNT java.lang.Float java.lang.Long
MIN, MAX, SUM java.lang.Float java.lang.Float
AVG java.lang.Float java.lang.Double
COUNT java.lang.Float java.lang.Long
MIN, MAX, SUM java.math.BigDecimal java.math.BigDecimal
AVG java.math.BigDecimal java.lang.Double
COUNT java.math.BigDecimal java.lang.Long
MIN, MAX java.lang.String java.lang.String
COUNT java.lang.String java.lang.Long
MIN, MAX java.util.Date java.util.Date
COUNT java.util.Date java.lang.Long
MIN, MAX java.sql.Date java.sql.Date
COUNT java.sql.Date java.lang.Long
MIN, MAX java.sql.Time java.sql.Time
COUNT java.sql.Time java.lang.Long
MIN, MAX java.sql.Timestamp java.sql.Timestamp
COUNT java.sql.Timestamp java.lang.Long
Aggregate Function Argument data type Expected return type