Meaningless Drivel is fun!
The moose likes EJB and other Java EE Technologies and the fly likes EJB-QL problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB-QL problems" Watch "EJB-QL problems" New topic

EJB-QL problems

Stephen Lee
Ranch Hand

Joined: Dec 11, 2001
Posts: 74
I want to know the details about the new function of EJB-QL. I have 2 problems in using EJB-QL, so I want to know whether they are supported in BES5.02:
1) Could I implement the ORDER BY part dynamically? so that it will be
SELECT OBJECT(e) FROM EmployeeSchema AS e
WHERE <somecondition>
ORDER BY <generated dynamically, depends on the input parameters>
2) Could I implement the WHERE part dynamically? as there are search function in my project.....
e.g. the user can search the employee by the sex, or by the age range........
How can I implement the above functions? Thanks!
I agree. Here's the link:
subject: EJB-QL problems
It's not a secret anymore!