3 Replies Latest reply on Sep 16, 2003 9:10 AM by Carlo de Wolf

    JBoss NOT EJB 2.0 Compliant ??!!!

    Dan Desch Newbie

      Okay, first of all, sorry for that subject line. I have a question that no one has replied to for several days. So I looked around and noticed that the questions that do get answered seem to have subject lines with two common characteristics: 1. provocative language, and 2. one or more exclamation points.

      I do not actually think that JBoss isn't compliant, but I am seeing error messages on startup that make it appear as if it weren't compliant

      Details:

      -> JBoss version 3.2.1.
      -> Attempting an EJBQL query that selects records from a Microsoft SQL Server database based on a range of value in one particular field using a WHERE clause.
      -> All entity beans implemented 100% CMP and CMR.

      On startup of JBoss, I get this message:
      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT object (a) FROM Account a WHERE a.accountNumber > ?1 AND a.accountNumber < ?2
      AND a.company.companyId = ?3'; - nested throwable: (org.jboss.ejb.plugins.cmp.e
      jbql.ParseException: Encountered ">" at line 1, column 56.
      Was expecting one of:
      "=" ...
      "<>" ...
      )

      So, it looks like JBoss is expecting only equal ("=") or not-equal ("<>") relationships, no greater than or less than allowed. I know that can't be right. The JBossCMP.pdf document I purchased from this very web site shows examples of EJBQL using the WHERE clause with the greater than symbol ("WHERE badness > ?1" or something like that). So, there must be something wrong with a config file somewhere or an obsolete jar file or something, but I have no idea where to look.

      Also, I had a colleague who works in a different office, and who runs a different version of JBoss (3.2.0) try this same query using the same beans and interfaces and ejb-jar.xml, and he gets the exact same error message.

      Anybody out there succesfully using the greater than and less than symbols in a WHERE clause in EJBQL? Did you have to do some sort of chicken swinging to get it to work? Do I have to buy some other document to instruct me on the eternal mysteries and show me the secret handshake? I'll gladly do that if that's what it takes, but I have no idea where to look.