File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes EJB-QL Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB-QL Question" Watch "EJB-QL Question" New topic

EJB-QL Question

Sloan Bowman
Ranch Hand

Joined: Jan 21, 2003
Posts: 107
I am having problems with finder methods on the home interface returning the correct values. For example i have a Client entity bean setup and a Contact entity bean setup. I have a 1 to many relationship between the two, the client is the 1 and the contact is the many. I am trying to run a simple EJB-QL statement and return all Contact entity objects to work with the data. When I run the query it seems to return the right number of entity beans but they are of the wrong type so when I cast them to the proper type my application fails and throw an exception. After debuging with Eclipse it appears that the entity objects being return are Client entity beans instead of the Contact entity beans which are supossed to be returned. Below is application deployment and query.

AppServer: JBoss 3.2.5

EJB-QL: Select Object(co) FROM Client AS c, IN (c.contacts) AS co;

Deployment descriptors


Client descriptor

Contact descriptor:

relationship descriptor:

Client Code (In a session bean)

Thanks for your help. Once I get past this hurdle I think I will have a much better understanding of what I am doing wrong.
Sloan Bowman
Ranch Hand

Joined: Jan 21, 2003
Posts: 107
For those of you interested the problem I was facing was being stupid and forgetting that finder methods only return the native local of the object. I converted these queries to select methods and used the selcts in the entity bean business method and it worked like a champ.
Bruce Sheng

Joined: Feb 13, 2003
Posts: 4
Can you post the correct local home definition and it's deployment descriptor?

Sleep is true,and clear-head is false!
I agree. Here's the link:
subject: EJB-QL Question
It's not a secret anymore!