1 Reply Latest reply on Aug 27, 2002 1:40 PM by Dain Sundstrom

    does Jboss3.0.0+jetty support > in jboss-ql

    hongmei Newbie

      Hi, all

      Is there anybody know how to write correct jboss-ql for query things back which is greater than? I put the following in my jbosscmp-jdbc.xml, but keeps complaining about it was expecting "=", "<>"....

      in jbosscmp-jdbc.xml:

      ...
      <jboss-ql>
      <![CDATA[SELECT OBJECT(a) FROM VDS AS a WHERE a.security = ?1 OR a.security > ?1 ]]>
      </jboss-ql>
      ...



      Thanks,

      hongmei

        • 1. Re: does Jboss3.0.0+jetty support > in jboss-ql
          Dain Sundstrom Master

          I suggest you read the EJB-QL specification or a good book on the subject. EJB-QL is strongly typed and very restrictive. What is the type of a.security? Is it a string or an object? EJB-QL only allows the > opperator for datetime values and arithmetic (numeric) values.

          The newest version of JBossQL is much more relaxed and supports the > operator for strings.