This content has been marked as final.
Show 2 replies
-
1. Re: EJB-QL limitations
juha Jan 8, 2004 5:14 AM (in response to gdemir)From EJBQLParser.jjt:
void ComparisonExpression() #void : {} { ( StringValue() ( <EQ> { jjtThis.opp="="; } | <NE> { jjtThis.opp="<>"; } ) StringExpression() ) #StringComparison | ( BooleanValue() [ ( <EQ> { jjtThis.opp="="; } | <NE> { jjtThis.opp="<>"; } ) BooleanExpression() ] ) #BooleanComparison | ( DatetimeValue() ( <EQ> { jjtThis.opp="="; } | <GT> { jjtThis.opp=">"; } | <LT> { jjtThis.opp="<"; } | <NE> { jjtThis.opp="<>"; } ) DatetimeExpression() ) #DatetimeComparison | ( EntityBeanValue() ( <EQ> { jjtThis.opp="="; } | <NE> { jjtThis.opp="<>"; } ) EntityBeanExpression() ) #EntityComparison | LOOKAHEAD(ArithmeticValue() ( <EQ> | <GT> | <GE> | <LT> | <LE> | <NE> ) ) ( ArithmeticValue() ( <EQ> { jjtThis.opp="="; } | <GT> { jjtThis.opp=">"; } | <GE> { jjtThis.opp=">="; } | <LT> { jjtThis.opp="<"; } | <LE> { jjtThis.opp="<="; } | <NE> { jjtThis.opp="<>"; } ) SingleValueDesignator() ) #ArithmeticComparison | BetweenExpression() }
Care to expand what in the EJB-QL is not supported? -
2. Re: EJB-QL limitations
gdemir Jan 11, 2004 10:40 AM (in response to gdemir)Hi,
SELECT OBJECT(o) FROM Holiday AS o WHERE o.hdate BETWEEN ?1 AND ?2
or
SELECT OBJECT(o) FROM Holiday AS o WHERE o.hdate >= ?1 AND o.hdate <= ?2
Both give parse errors, the error indicate JBoss parser was expecting either >, <, =, <>. But strangely, the parser is not expecting BETWEEN, >= or <=. Why is this? Such an impressive server with impressive implementation novelties, but does not support the EJB-QL fully.
JBoss 3.2.3, jdk 1.4.2_03, Linux.