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

[hyao]

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

[dsundstrom]

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.