RE: J2EE Question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 24 Apr 2003 08:26:40 -0800
Message-ID: <F001.005887B9.20030424082640@fatcity.com>

Thanks everyone. In the end we decided to "go along" and add the extra key. It helps to know at least that we aren't alone in this.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, April 24, 2003 9:47 AM
To: Multiple recipients of list ORACLE-L

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).
-- 
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).

Received on Thu Apr 24 2003 - 11:26:40 CDT