aspose file tools*
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
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