2 Replies Latest reply on Mar 23, 2002 5:28 PM by Dain Sundstrom

    EJB QL problems

    Claude Newbie


      I'm translating some CMP entity beans from v1.1 to v2.0 and I have some problems:


      In my EJB1.1 beans I had some finder methods that could return objects per bunches of 10 or 20 objects.
      I don't find a way to implement it. For obvious performance raisons, I don't want to use a "findAll" finder method and sort the object in the client.
      (In my EJB 1.1 beans I used the "rownum" feature of Oracle)


      In my EJB1.1 beans I had finder methods that compare strings, but I don't want them to be case-sensitive.
      (In EJB1.1 I used the "upper" function of Oracle)

      Does anyone have an idea?

      Thanks you very much

        • 1. Re: EJB QL problems
          Claude Newbie

          Some more information about my first problem:
          What I want to implement is a finder method that returns X objects starting from the Yth object. Typically used in a web application where we want to display search results (like this forum, for example)


          • 2. Re: EJB QL problems
            Dain Sundstrom Master

            JBossCMP has a declared-sql query specification which is similar to the JAWS finder specification. For more information read the jbosscmp-jdbc dtd, which is documented, or buy the JBossCMP docs.