[ObjectName: jboss.j2ee:jndiName=Testa,service=EJB
 state: FAILED
 I Depend On:
 Depends On Me: org.jboss.deployment.DeploymentException: Error compiling EJB-QL
 statement 'select  Object(o) from Testa o ORDER BY o.c'; - nested throwable: (o
rg.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "ORDER" at line 1, co
lumn 32.
Was expecting one of:
    <EOF>
    "," ...
    )]

ringayumi wrote:
QL is not supported the "Order By" now!!

May be the EJB3.0 include it.

11.2 EJB QL Definition
EJB QL uses a SQL-like syntax to select objects or values based on the abstract schema types and relationships
of entity beans. The path expressions of EJB QL allow the Bean Provider to navigate over
relationships defined by the cmr-fields of the abstract schema types of entity beans.
This chapter provides the full definition of the language.
An EJB QL query is a string which consists of the following clauses:
• a SELECT clause, which determines the type of the objects or values to be selected.
• a FROM clause, which provides declarations that designate the domain to which the expressions
specified in the SELECT clause and WHERE clause of the query apply.
• an optional WHERE clause, which may be used to restrict the results that are returned by the
query.
• an optional ORDER BY clause, which may be used to order the results that are returned by the
query.