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 "=", "<>"....
<![CDATA[SELECT OBJECT(a) FROM VDS AS a WHERE a.security = ?1 OR a.security > ?1 ]]>
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.