• Post Reply Bookmark Topic Watch Topic
  • New Topic

Beginner needs help with EJB-QL and EJB relations.  RSS feed

 
Julien Martin
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
Further to an earlier post, I have more questions relating to ejbs and ejb-ql.
I have three tables in a relational database:
*First table, called "establishments", contains two fiels "db_establishment_id" and "db_establishment_name".
Here is a sample:

*Second table, called "categories", contains two fields "db_category_id" and "db_category_name"
Here is a sample:


*Third table, called "establishments_qualifiers", contains two fields "db_establishment_id" and "db_id_category"
Here is a sample:

These THREE tables map to TWO ejbs in a many-to-many bi-di relation (Is this the way it should be?) as follows:

Ideally I would like an EstablishmentEJB instance that contains a list of categories. How do I do that? Do I need to modify the design of my application? What is the ejb-ql I need?
Thanks in advance,
Julien Martin.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!