Hi,
I've just started using DQL in order to execute something like the following statement
:
SELECT OBJECT(o) FROM CusOrderItemEJB o WHERE o.product = ?1 and o.cycle IN (?2, ?3,
?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18)
This statement is generated (as per the DQL example in the free docs) in an ejbHome
method which then calls the ejbSelectGeneric method.
When I call the method, with the above SQL, I get the following error :
2004-10-05 14:52:04,289 [http-0.0.0.0-8080-Processor24] ERROR [STDERR]
org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "o.cycle IN" at line 1,
column 68.
Was expecting one of:
"ABS" ...
"CONCAT" ...
"COUNT" ...
"MAX" ...
"MIN" ...
"AVG" ...
"SUM" ...
"LENGTH" ...
etc.
It appears that the compiler doesn't support the SQL 'IN'?
Surely this has been used ... so what am I doing wrong?
Regards
tim
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3850410#3850410
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3850410
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
