2 Replies Latest reply on Apr 23, 2002 12:49 PM by starco

    QL for JBoss 3.0 RC1

    starco

      Hello.

      Does JBossQL support aggregate functions for SQL? Example: MIN(x), AVG( [DISTINCT] x), COUNT( [DISTINCT] x), and so on.
      May be I can do it with Dynamic JBossQL or somehow else?

      For example I can write the the following QL statement for WebLogic QL Extension for EJB QL:
      SELECT COUNT (DISTINCT subOrder.ship_date) FROM OrderBean AS subOrder
      Can I write similar statement for JBoss? And how?

      It would be nice if anybody will say where I can find the documentation for JBossQL and Dynamic JBossQL.

      Thanks in advance.

        • 1. Re: QL for JBoss 3.0 RC1
          dsundstrom

          > Does JBossQL support aggregate functions for SQL?
          > Example: MIN(x), AVG( [DISTINCT] x), COUNT(
          > [DISTINCT] x), and so on.

          No. Maybe JBoss 3.1. I think I'm going to add full group by/ having support.

          > May be I can do it with Dynamic JBossQL or somehow
          > else?

          Nope, you can use a custom finder.

          > For example I can write the the following QL
          > statement for WebLogic QL Extension for EJB QL:
          > SELECT COUNT (DISTINCT subOrder.ship_date) FROM
          > OrderBean AS subOrder
          > Can I write similar statement for JBoss? And how?

          Not yet.

          > It would be nice if anybody will say where I can find
          > the documentation for JBossQL and Dynamic JBossQL.

          I am still writing it, in the mean time look at the JBossOne CMP slides.

          • 2. Re: QL for JBoss 3.0 RC1
            starco

            Thank you for respondes.