[Mark Sanders]

I am using Eclipse 3.2 on Win XP SP2 with MyEclipse 5 which I just downloaded this morning to try out before I subscribe. If this works for me, I’m in.

I am trying to generate and ERD from our Oracle 8i Database. I used the help documents (very nice). I was able to connect to the database just fine. I was able to create an ERD, but there are not relationship routes showing.

Did I miss a step or do I need to subscribe in order to unlock certian features?

Thanks in advance,

littleccguy

[Haris Peco]

littleccguy,

Have you defined relationship (foreign key) in database.The ERD diagram load relation informations from databases foreign keys

Regards,

[Mark Sanders]

The Oracle database is used for the backend of Agile (our document control software), so we had nothing to do with cofiguring the database. Earlier I had used Visual Studio 2005 and the data adapter to pull in the tables. I could show all the tables, and there were connection paths between the tables that we know work together. I do not refer to them as relationships here because the image in VS looks more like connect the dots between tables using the same primary key.

When I do the ERD in MyEclipse, not only do I see all the primary keys like I do in VS, but I also see the foriegn keys, indexes, dependencies, ect…. I can definatly see much more information through MyEclipse, I just don’t understand why I don’t see the routes.

I have a MS SQL database I put together a few weeks ago with the help of my mentors. I think I’ll give that a try because I know the relationships there. The table list is not as big as the Agile db, but I’m hoping it will show me something.

I saw a post earlier on using the MS files I need to connect, so I should be able to figure the MS connection out on my own – I hope. 🙂

[Haris Peco]

littleccguy,

I am not sure what is your “route”, but you will got relationships for all your foreign key definitions.You can try with Oracle’s HR schema (it is example schema in Oracle, but I am not sure if it exists for Oracle8i – if no then you can download or install HR schema separatelly)
If you have cross-schema relationships (foreign key between tables in different schema), then you will not see relations.

Please, can you post ddl (right click on table in db explorer and call Generate DDL or Generate Advanced DDL) for your 2 tables, which have relations (route) ?
Thanks,

[Mark Sanders]

Peco,

Thanks for the idea of the Generate DLL. Boy was I mistaken. I just looked through most of the tables I thought had foriegn keys, and they don’t. If there were any foriegn keys, I should see them listed in ‘Table/Objects’ window – right. My fault – still new MyEclipse. Wow – what does that say for Agile.

I don’t see the HR Schema and I’m not sure, but it doesn’t look like there is a cross schema.

Here are two of the DLLs I look at. I really don’t think this is a MyEclipse issue. I think we have a poorly configured db in Agile.

Thanks for the help Peco!

————————————————

create table “AGILE”.”BOM”(
“ID” NUMBER(10) not null,
“ITEM” NUMBER(10),
“ITEM_NUMBER” VARCHAR2(75),
“FIND_NUMBER” NUMBER(5),
“SEQ” NUMBER(5),
“QUANTITY” VARCHAR2(20),
“DESCRIPTION” VARCHAR2(100),
“NOTES” VARCHAR2(512),
“DATE01” DATE,
“DATE02” DATE,
“DATE03” DATE,
“DATE04” DATE,
“DATE05” DATE,
“TEXT01” VARCHAR2(50),
“TEXT02” VARCHAR2(50),
“TEXT03” VARCHAR2(50),
“TEXT04” VARCHAR2(50),
“TEXT05” VARCHAR2(50),
“LIST01” NUMBER(10),
“LIST02” NUMBER(10),
“LIST03” NUMBER(10),
“LIST04” NUMBER(10),
“LIST05” NUMBER(10),
“LIST06” NUMBER(10),
“LIST07” NUMBER(10),
“LIST08” NUMBER(10),
“LIST09” NUMBER(10),
“LIST10” NUMBER(10),
“CHANGE_IN” NUMBER(10),
“CHANGE_OUT” NUMBER(10),
“PRIOR_BOM” NUMBER(10),
“MULTITEXT30” VARCHAR2(1023),
“MULTITEXT31” VARCHAR2(1023),
“FLAGS” VARCHAR2(32) default ‘00000000000000000000000000000000’,
“COMPONENT” NUMBER default ‘0’,
constraint “BOM_PK” primary key (“ID”)
);

create unique index “BOM_PK” on “AGILE”.”BOM”(“ID”);
create index “BOM_IDX1” on “AGILE”.”BOM”(“ITEM”);
create index “BOM_IDX2” on “AGILE”.”BOM”(“ITEM_NUMBER”);
create index “BOM_IDX3” on “AGILE”.”BOM”(“CHANGE_IN”);
create index “BOM_IDX4” on “AGILE”.”BOM”(“COMPONENT”);

———————————————————————————-

create table “AGILE”.”CHANGE”(
“ID” NUMBER(10) not null,
“CLASS” NUMBER(10),
“SUBCLASS” NUMBER(10),
“CHANGE_NUMBER” VARCHAR2(30),
“CHANGE_REV” VARCHAR2(20),
“CATEGORY” NUMBER(10),
“STATUS” NUMBER(10),
“REASON_CODE” NUMBER(10),
“ORIGINATOR” NUMBER(10),
“OWNER” NUMBER(10),
“CREATE_DATE” DATE,
“RESUME_DATE” DATE,
“EFFECTIVE_FROM” DATE,
“EFFECTIVE_TO” DATE,
“RELEASE_DATE” DATE,
“DESCRIPTION” VARCHAR2(1023),
“REASON” VARCHAR2(1023),
“TRANSFERRED” VARCHAR2(128),
“MODIFYDATE” DATE,
“OBJVERSION” NUMBER,
“DELETE_FLAG” NUMBER,
“SUBMIT_DATE” DATE,
“ROUTE_DATE” DATE,
“PRODUCT_LINES” VARCHAR2(255),
“FLAGS” VARCHAR2(32),
“WORKFLOW_ID” NUMBER,
“STATUSTYPE” NUMBER,
“FINALCOMPLETE_DATE” DATE,
“PROCESS_ID” NUMBER,
“IN_REVIEW” NUMBER,
constraint “CHANGE_PK” primary key (“ID”)
);

create unique index “CHANGE_PK” on “AGILE”.”CHANGE”(“ID”);
create index “CHANGE_CTX_IDX” on “AGILE”.”CHANGE”(“DESCRIPTION”);
create index “CHANGE_IDX2” on “AGILE”.”CHANGE”(“CHANGE_NUMBER”);
create index “CHANGE_IDX3” on “AGILE”.”CHANGE”(“STATUS”,”OWNER”);
create index “CHANGE_IDX4” on “AGILE”.”CHANGE”(“STATUS”,”ORIGINATOR”);
create index “CHANGE_INREW_IDX” on “AGILE”.”CHANGE”(“IN_REVIEW”);
create index “CHANGE_PROCESS_IDX” on “AGILE”.”CHANGE”(“PROCESS_ID”);

——————————————————————————————

[Haris Peco]

littleccguy,

It looks that HR schema doesn’t exists in Oracle 8i on default.It is not important for now.I have seen that your tables haven’t foreign key and no relations (routes) in ERD diagram.ERD diagram can’t know relations if it is not defined in databases (with foreign keys)
Some applications doesn’t use referential integrity (foreign keys) in database, because it is very old system or don’t want use it, because easier support (???).Clients have to care for integrity in this systems.Disadvantage is that this system can’t work good with different clients.

You are correct, this is not MyEclipse’s issue

Regards,

[Author]

Posts