I hit this constantly...
the developers say "oh, but the open source object program we are using
can't handle concatenated keys, we need you to put another key in
there"
they aren't lying to you, but how something in this day and age, with
databases and relational theory matured, can NOT handle concatenated
keys drives me nuts
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> 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).
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 - 09:46:52 CDT
