Beginner needs help with EJB-QL and EJB relations.
posted 12 years ago
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.