> For cmp 2.0, we're not ready to use ejb-ql, mostly
> because of the lack of an order by clause.
JBossQL supports an order clause (exactly as proposed in the EJB 2.1 public draft). This is described in the JBossCMP documentation.
> Do custom finders have to be written in ejb-ql? Or
> is there an equivalent file to jaws.xml? I thought
> it might be jbosscmp-jdbc.xml files, but I couldn't
> find a good example of the syntax. I want the syntax
> for custom finder methods, not the new 2.0 select
There are several ways to specify a query: EJB-QL, JBossQL, DynamicQL, DeclaredSQL and BMP style custom finders. All of these are described in the JBossCMP documentation available at flash line.