Hi,
This sounds so exciting. I have about 90 tables to be implemented with CMP.
If I can do this way, I probably can reduce the number of CMP implementation
to about 70 regarding my database schema. That is a lot.
When you say that I can define the field as Object (like ContactInfo) in Person
CMP, does that mean that the fields in the Object (ContactInfo) and the fields in
Person unnecessarily have to be in one table? If they are not in one table, I just
don't understand how you specify them when you deploy the bean. By the way,
I am using Weblogic Server.
In addition, could you please recommand me some references which covers this
specific issue? I have serveral books with me and none of them talk about this.
Thanks.
-John
-----Original Message-----
From: Juan Lorandi (Chile) [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: Re: bean design problem for one to many relationship
yes, you can use object's in CMP...
I do that all the time with Orion Server
just define the field as java.lang.Object, and the container's persistance
manager
will serialize the object and store it in a BLOB field in the database (for
Oracle, for Sybase & SQL Server it will be image or varbinary).
HTH
JP
PS: Of course, if you try to access the DB directly thru SQL, you will have
to deserialize
the Object manually. This will present additional difficulties if you aren't
using Java.
> -----Original Message-----
> From: Jianguo Wang [mailto:[EMAIL PROTECTED]]
> Sent: Jueves, 01 de Febrero de 2001 16:47
> To: [EMAIL PROTECTED]
> Subject: Re: bean design problem for one to many relationship
>
>
> Hi,
>
> When you say that I can put ContactInfo in a Person member, you mean
> to use BMP, don't you? To my understanding, it is impossible
> to use object
> as a member in CMP because it can not match a object with a
> field in the table.
>
> Please verify it for me.
>
> -John
>
> -----Original Message-----
> From: Juan Lorandi (Chile) [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 12:56 PM
> To: [EMAIL PROTECTED]
> Subject: Re: bean design problem for one to many relationship
>
> With this design, you could easily have 2 CMP beans that do
> just what you
> want.
> Alternatively, if contact info will only be accesible thru
> Person, you could
> store all ContactInfo
> in a Person member:
>
> (very PSEUDO pseudo-code)
> public class ContactInfo extends Object {
> public String UID;
> public String Type;
> public String Detail;
> }
>
> and in Person:
>
> ..
> public Vector contactInfoCollection;
> ..
>
> public addContact(ContactInfo contact);
> {
> contactInfoCollection.add(ContactInfo);
> }
>
>
> HTH
>
> JP
> > -----Original Message-----
> > From: Jianguo Wang [mailto:[EMAIL PROTECTED]]
> > Sent: Jueves, 01 de Febrero de 2001 14:42
> > To: [EMAIL PROTECTED]
> > Subject: bean design problem for one to many relationship
> >
> >
> > Dear friends,
> >
> > I have a design problem about one to many relationship. Can
> > anyone there give me
> > some suggestions,
> >
> > For simplicity's sake, let's say I have two tables
> > Person(UID, FirstName, LastName)
> > with primary key (UID) and ContactInfo(UID, Type, Detail)
> > with primary key (UID, Type).
> > A person may have more than one ContactInfo. For example,
> >
> > A record in the table "Person" is (777, John, Smith)
> > Corresponding to this person, there are two records in the
> > table "ContacInfo" like
> > (777, Email, [EMAIL PROTECTED])
> > (777, Phone, (850)123-4567)
> >
> > These information are provided at a time and can be saved in
> > array (mainly ContactInfo).
> > When I try to insert them into database, can I implement it
> > as CMP? or I have to
> > implement it as BMP? If I can do with CMP, does it mean that
> > I have to make a loop
> > to invoke home.create(UID, Type, Detail)?
> >
> > Thank you very much.
> >
> > -John
> >
>
> ==============================================================
> =============
> 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".
===========================================================================
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".
