QL « EJB « JSP-Servlet Q&A

1. Compare time using EJB QL?    coderanch.com

Hi all, I have been trying to display results that is not based within the specified time range. Anyone know how to compare time? It works fine if i am trying to find a particular time, but does not work if i compare within a range. The temporal type i used is Time and direction is bi-directional. For example: select v ...

3. EJB QL Failed    coderanch.com

Hi All, When I execute dynamic ejb ql as follows SELECT distinct OBJECT(o) FROM com_afl_global_entity_Partner o WHERE o.id IN (-1,780,1005,1091,1097) ORDER by o.name I got the following error org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "-" at line 1, column 85. Was expecting one of: "ABS" ... "COUNT" ... "MAX" ... "MIN" ... "AVG" ... "SUM" ... "LENGTH" ... "LOCATE" ... "SQRT" ... "MOD" ... "(" ...

4. EJB-QL count query????    coderanch.com

5. EJB-QL    coderanch.com

6. How to use EJB QL to query from Dual    coderanch.com