RE: J2EE Question

Alex - Sort of in-between. They are developing the code, but I keep hearing that if you use J2EE properly it will generate most of the code for you. That is one of the reasons they wanted the extra key. With the extra key they could treat all tables alike and the code would be generated automatically. If they had to concatenate the keys, then they would have to manually write the code that dealt with these tables.

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

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

Are the J2EE developers really developing the code or are they installing prewritten code? They should be able to concatenate the 2 keys, or write trigger that creates the concatenation in a 3rd field.

On Thu, 24 Apr 2003, DENNIS WILLIAMS 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Alex
  INET: axs_at_m-net.arbornet.org

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