Hi, Try some tools like Toplink(I havent used ) which allows you to to object to relational mapping and may solve some of your problems of using multiple tables for cmp.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Cheers Ashwani Kalra Sr. Mem. Dev. Staff Aithent Technologies India www.geocities.com/ashwani_kalra/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -----Original Message----- From: A mailing list for Enterprise JavaBeans development [mailto:[EMAIL PROTECTED]]On Behalf Of Swaminathan K N Sent: Thursday, December 20, 2001 2:44 PM To: [EMAIL PROTECTED] Subject: How about EJB 1.1 Hi all, We are currenlty using Websphere Application Server 4.0 and DB2 7.2 and VAJ 4.0. We have to stick to EJB 1.1 since IBM products dont support EJB 2.0( ok they say few features are supported but we want EJB QL ). We have a lot of relationships between tables. The tables are normalised. We dont want to change the db desing bcos of EJB....( not to denormalize ). To get a list of data, we need to combine 3 or 4 tables to get the relevant data. We have a short development time. We have decided to use only CMP Entity Beans.I can understand EJB 2.0 QL solves most of the Container Management Relationship Issues.Any problems u have still?? But we cant go for it since there is no support from IBM particularly for EJB QL The requirements are * Need to make the code portable to different application server and database * Smooth Transition from EJB 1.1 to EJB 2.0 in the near future when IBM supports it without much rework in the code Now the issues are * How to access the data where most of the times we need to combine 3 or 4 tables when i cant afford to use IBM specifc code. How to go for relationships between EJBs How to go about doing this task Please give ur suggestions at the earliest........................................ Thanks and Regards, Swaminathan K.N. **************************************************************************** This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. **************************************************************************** =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
