Forum:

EJB and other Jakarta /Java EE Technologies

CMR in entity bean

Greenhorn

Posts: 19

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Lets say I have EMPLOYEE table and a DEPT table. EMPLOYEE table has the deptid which is the foreign key. And I can establish CMR between the two entity beans.
If EMPLOYEE table does not have deptid column (ie there is no common columns between tables) can I still establish a CMR between the two entity beans?

Pradeep bhatt

Ranch Hand

Posts: 8946

I like...

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If EMPLOYEE table does not have deptid column (ie there is no common columns between tables) can I still establish a CMR between the two entity beans?

It is not possible to establish the relation since employee does not know the department and the departement is not even null , it does not just exist.

Groovy

Deepa Malhotra

Greenhorn

Posts: 19

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks Preadeep.
But if you look at the CMP example in Sun's tutorial, we have a Teams entity bean and a League entity bean. The underlying tables do not have any common columns, but the beans have a 1:* relationship established thro CMR.
Am I making sense?

Pradeep bhatt

Ranch Hand

Posts: 8946

I like...

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Can you please pass the link to the tutorial. I checked the j2ee 1.3 tutorial but did not mention of Leage entity. It was just Team and Player entities.

Groovy

Bill Dudney

Author

Posts: 234

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,
Is it possible that this is a *:* relationship and there is an association table between them? That seems to make sense (a team could be in more than one league).
Hope this helps.

TTFN,<br /> <br />-bd-<br /> <br /><a href="http://www.amazon.com/exec/obidos/ASIN/0471449156/qid=1064343733/sr=2-1/ref=sr_2_1/002-8375300-3666449" target="_blank" rel="nofollow">Jakarta Pitfalls</a> | <a href="http://www.amazon.com/exec/obidos/tg/detail/-/0471146153/qid=1064343733/sr=1-2/ref=sr_1_2/002-8375300-3666449?v=glance&s=books" target="_blank" rel="nofollow">J2EE AntiPatterns</a> | <a href="http://www.amazon.com/exec/obidos/tg/detail/-/0471462071/qid=1064343733/sr=1-3/ref=sr_1_3/002-8375300-3666449?v=glance&s=books" target="_blank" rel="nofollow">Mastering JavaServer Faces</a> | <a href="http://bill.dudney.net/roller/page/bill" target="_blank" rel="nofollow">Blog</a> | <a href="http://www.jroller.com/page/BillDudney" target="_blank" rel="nofollow">Eclipse Blog</a> | <a href="http://www.sourcebeat.com/TitleAction.do?id=2" target="_blank" rel="nofollow">Eclipse 3 Live</a>

Deepa Malhotra

Greenhorn

Posts: 19

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Here is the link for that tutorial:
http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/CMP.html
League and Teams have 1:* relationship. One League can have many teams and every team just belongs to League.

What's wrong? Where are you going? Stop! Read this tiny ad:

Smokeless wood heat with a rocket mass heater

https://woodheat.net