This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes EJB and other Java EE Technologies and the fly likes using min function in ejb ql of foreign key Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "using min function in ejb ql of foreign key" Watch "using min function in ejb ql of foreign key" New topic
Author

using min function in ejb ql of foreign key

Kedar Dravid
Ranch Hand

Joined: May 28, 2004
Posts: 333
SELECT MIN(o.orgUnitId) FROM ProcessedOrganization o
This is query i am using ,in this case

ProcessedOrganization Entity have orgUnitId as primaryKey as well as
foreign key reference.
when i am going to generate rmic for this Ejbql then it showing error
Invalid SELECT containing either expression,parameter,or multiple elements.
I am using ejb 2.1 so there is no problem of version
can u help me?
JayaSiji Gopal
Ranch Hand

Joined: Sep 27, 2004
Posts: 303
Hi!

Can u plz post the exact stack trace tht u received?


SCJP 1.4, SCWCD 1.4<br /> <br />Thanks in advance!<br />Jayashree.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: using min function in ejb ql of foreign key