jaws vs. jbosscmp-jdbc vs. ejb-ql

[jlisle]

Hi all.

I'm in the process of converting cmp 1.1 entity beans to cmp 2.0 beans.

My applications has several custom finder methods. Previously, I put the finder definitions in a jaws.xml file, one for each jar file.

For cmp 2.0, we're not ready to use ejb-ql, mostly because of the lack of an order by clause.

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 methods.

Thanks in advance.
Josh

[dsundstrom]

> 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
> methods.

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.