Bugs item #981228, was opened at 2004-06-28 15:54
Message generated for change (Comment added) made by loubyansky
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=981228&group_id=22866
Category: JBossCMP
Group: v3.2
>Status: Closed
>Resolution: Invalid
Priority: 5
Submitted By: Tolja Zubow (zubow)
Assigned to: Alexey Loubyansky (loubyansky)
Summary: JBoss EJB-QL numeric comparison error
Initial Comment:
Hi,
the EJB-QL allows the use of operators like <= and >=
but this does not work with Jboss 3.2.4.
Here is my query (ejb-jar.xml):
<ejb-ql><![CDATA[
select object (ca)
from CommissionAccount ca
where ca.receivingOfficeId is null
and ca.commissionModel.clientId = ?1
and ca.commissionTimeFrameEnd > ?2
and ca.commissionTimeFrameEnd <= ?3
]]></ejb-ql>
and here the error message:
org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered "<=" at line 6, column 68. Was expecting
one of:
">" ...
"<" ...
"=" ...
"<>" ...
)
Greetings,
Tolja
----------------------------------------------------------------------
>Comment By: Alexey Loubyansky (loubyansky)
Date: 2004-06-28 23:31
Message:
Logged In: YES
user_id=543482
Then by the spec, it's not allowed. You should use JBossQL
instead.
----------------------------------------------------------------------
Comment By: Tolja Zubow (zubow)
Date: 2004-06-28 21:11
Message:
Logged In: YES
user_id=600416
commissionTimeFrameEnd is of type
java.sql.Timestamp
----------------------------------------------------------------------
Comment By: Alexey Loubyansky (loubyansky)
Date: 2004-06-28 20:57
Message:
Logged In: YES
user_id=543482
What is the type of commissionTimeFrameEnd field?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=981228&group_id=22866
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
