1 Reply Latest reply on Oct 6, 2004 10:52 AM by timshaw

    EJBQL Problem

    mbo

      Hi all

      I currently have the problem that I get a "ParseException, Expecting AND OR..." with the following EJBQl statement on JBoss 3.2.3:

      select object(rel) from Relationships rel WHERE rel.stSourceId = ?1 ORDER BY rel.stRelationshipId DESC, rel.stTimestamp DESC


      I don't really see an error here. According to the handbook, this should work. I have also tried it with just one ORDER BY statement - also no success.

      Help is greatly appreciated.

      Cheers,
      Michael


        • 1. Re: EJBQL Problem
          timshaw

          1) Remove the ORDER BY bits - check this works
          2) Create identical entry in jbosscmp-jbbc.xml (with ORDER BY), replacing 'ejb-ql' tag with 'jboss-ql'. Empty the 'ejb-ql' tag in ejb-jar.xml

          Try again.

          G'luck

          tim