1 Reply Latest reply on Jul 8, 2002 10:34 PM by Dain Sundstrom

    jaws vs. jbosscmp-jdbc vs. ejb-ql

    Josh Lisle Newbie


      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

        • 1. Re: jaws vs. jbosscmp-jdbc vs. ejb-ql
          Dain Sundstrom Master

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