2 Replies Latest reply on Jan 27, 2004 9:22 AM by kris77

    EJBQL problem

    kris77

       

      "kris77" wrote:
      <![CDATA[select object(o) from PerkTropas o where o.urtz <> ?1 AND o.idter NOT IN (select o1.idter from PerkTropas o1 where o1.urtz = ?1)]]>


      This ejbql statement, that in Weblogic is OK, with jboss 3.2.1 generates a org.jboss.ejb.plugins.cmp.ejbql.ParseException:

      Encountered "o.urtz" at line 1, column 73.
      Was expecting one of:
      "NOT" ...
      <STRING_VALUED_PATH> ...
      <COLLECTION_VALUED_PATH> ...
      "(" ...
      "CONCAT" ...
      "SUBSTRING" ...
      <BOOLEAN_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      <ENTITY_VALUED_PATH> ...
      <IDENTIFICATION_VARIABLE> ...
      <NUMERIC_VALUED_PATH> ...


      Can you see the problem ? Thanks.


        • 1. Re: EJBQL problem
          mikelarnett

           

          "mikelarnett" wrote:
          I had a similar problem that was related to the fact that JBoss 3.2.1 does not handle BigInteger or BigDecimal objects correctly. What are the objects' types to which you have mapped your columns?
          -MLA


          • 2. Re: EJBQL problem
            kris77

             

            "kris77" wrote:
            I found that the query "IN ( SELECT .....)" is not EJBQL standard, it's a Weblogic extension !

            Bye, Kris.