ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Learning EJB QL
Subject:   want to know more
Date:   2003-01-07 17:30:51
From:   anonymous2
Thanks for the useful tutorial.


I am new to EJB and wondering how the EJB-QL can handle joins to get combination of fields that are spread across tables, such as, I have some part of the user info in one table and some usage values by this user in another, and I would like to get the combined values in a form of Collection (that is analogous to the SQL query to have some fields from the first table and the others from the secound and returns as a new row per user). This would not be some known type of an object but a "collection" of fields consisting of the two entiry bean' access methods.


Is this how it works or EJB can't do it and does this in a different way?


Thanks.


1 to 1 of 1
1 to 1 of 1