How to access two tables while using CMP?
2 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   sundar_ramalingam
Posted On:   Monday, April 9, 2001 05:11 PM

Hi everbody,
I need to know how we can access two tables using CMP.I'll appreciate when you are returning with different types of accessing thro CMP.
regards,
Sundhar

Report | Quote This | Send private message | Reply | Print

Re: How to access two tables while using CMP?

Posted By:   venkatasubbaiah_chenna  
Posted On:   Monday, April 9, 2001 10:40 PM

Hi sundar

you can use TOPLink for weblogic tool for mapping one EJB with multitables.Pl go through www.webgain.com product TOPLink for weblogic.This tool acts as a mediator for our EJB and DB.You can connect to any DB also.

Pl shootup yr further doubts on this if required.

venkat
Report | Quote This | Send private message | Reply | Print

Re: How to access two tables while using CMP?

Posted By:   AlessandroA_Garbagnati  
Posted On:   Monday, April 9, 2001 07:09 PM

Hi,

Theoretically you cannot use CMP to access to an entity bean mapped to two different tables.
There is a trick that I haven't tested yet but it should work, that is mapping a CMP entity bean to a view (instead of a table). The view should be the full join (that means all records) of the two tables. Again, I haven't tested this yet, and if you try this solution please, let us know the outcome.


Anyway, there is another thread about this subject: http://www.jguru.com/forums/view.jsp?EID=398085.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact