This is usual when you are doing OOPS . Its easy to hadnle object by
object_id which is a synthetic key .
-ak
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, April 24, 2003 7:56 AM
> Hi:
>
> If this join table would not going to have it's own child table(s), then
two
> FKs are good enough. But I often find that if we ever need to add another
> child table to this join table,then a PK in this join table would make
> things much easier to handle. It is just one more PK and one sequence to
add
> (take some disk space though), but it shouldn't be any problem. I do it
all
> the time.
>
> Guang
>
>
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of DENNIS
> > WILLIAMS
> > Sent: Thursday, April 24, 2003 10:07 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: J2EE Question
> >
> >
> > We are in the process of creating some significant new
> > schemas. Everything
> > is being normalized, by the book. Now the Java developers are
> > saying that on
> > the associative entities, where many-to-many relationships
> > are resolved by
> > an extra table, they want an artificial key to be added.
> > Normally these
> > tables have two keys, one from each parent table. But the
> > developers want an
> > additional sequential key added to help them track this
> > entity. They say it
> > makes it easier to keep track of this object in the EJBs. Has anyone
> > encountered this situation? Not being familiar with J2EE, I
> > haven't a clue
> > whether this is a reasonable request.
> >
> > Dennis Williams
> > DBA, 40%OCP, 100% DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: gmei
> INET: gmei_at_incyte.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: AK
INET: oramagic_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 24 2003 - 12:12:08 CDT
