RE: Non Oracle UML question

From: Clarke, Andrew <andrew.clarke_at_logicacmg.com>
Date: Mon, 27 Feb 2006 16:53:21 -0000
Message-ID: <F8BFC29EA6247145AD72256D5B7925FF2D194B@uk-ex010.groupinfra.com>

Gints

This made me laugh but not in a nasty way. Well done for finding it!

I've never noticed a bug like this, I guess because I always do modelling in the schema owning account (which never has the DBA role). Schemester is not actively supported anymore, so I guess this is unlikely ever to get fixed.

Cheers, APC

-----Original Message-----
From: Gints Plivna [mailto:gints.plivna_at_gmail.com] Sent: 27 February 2006 16:30
To: Clarke, Andrew
Cc: Lee.Robertson_at_acxiom.com; oracle-l_at_freelists.org Subject: Re: Non Oracle UML question

Khe downloaded it and found an interesting bug immediately ;) I have many similar schemas with the same structure for testing purposes and they all can see each other because of DBA role.

So as a result for a table I got following FK constraint generation statement

ALTER TABLE CMIS_DB2.IRA_ADOPCIJAS
ADD CONSTRAINT FK_RADP_KAIM FOREIGN KEY (RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_K AIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID, RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KA IM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,R ADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAI M_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RA DP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM _ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RAD P_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP _KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_I D,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID) REFERENCES

CMIS_DB4.KLS_AKT_IEMESLI(KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID
,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID)

But I only have 4 schemas (with identical constraint name) so the tool multiplies not only with 4 ;)))

Gints

2006/2/27, Clarke, Andrew <andrew.clarke_at_logicacmg.com>:
> It's not a UML tool but Schemester is free and a heck of a lot better
at
> modelling databases than Visio: http://www.schemester.co.uk/
>
> If you do have Vision already and you want to add UML capability Pavel
Hruby
> has free ones on his web site:
> http://www.phruby.com/index.html
>
> Cheers, APC
>
>
>
> A P Clarke
> Technical Consultant
> LogicaCMG UK Public Sector Division
> Stephenson House
> 75 Hampstead Road
> London
> UK
> NW1 2PL
> Direct Tel: +44 (0)207 446 4006
> Fax: +44 (0)207 446 1352
> Email: andrew.clarke_at_logicacmg.com
> ________________________________
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Robertson Lee - lerobe
> Sent: 24 February 2006 09:59
> To: oracle-l_at_freelists.org
> Subject: Non Oracle UML question
>
>
> Hi,
>
> Sorry for the non Oracle specific question but I was wondering what
you guys
> out there were using to build models (LDMs, PDMs etc.) ?
>
> I would prefer cheap or free tools if possible but any recommendations
would
> be great.
>
> TIA
>
> Lee
>

***
The
> information contained in this communication is confidential, is
intended
> only for the use of the recipient named above, and may be
> legally

privileged.

If the reader of this message is not the intended
> recipient, you are

hereby notified that any dissemination, distribution or
> copying of this

communication is strictly prohibited.

If you have received
> this communication in error, please resend this
communication to the sender
> and delete the original message or any copy
of it from your computer
> system.

Thank
> You.

>
>
>
>
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be
copied,
> disclosed to, retained or used by, any other party. If you are not an
> intended recipient then please promptly delete this e-mail and any
> attachment and all copies and inform the sender. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 27 2006 - 10:53:21 CST