| Some foreign keys are not shown [message #7994] |
Tue, 24 January 2006 14:44  |
Eclipse User |
|
|
|
Originally posted by: reply-to.newsgroup.net
Hi there,
I have noticed that some foreign key relations are not shown in the
"Data Source Explorer" view (M3, Jan 20). The missing foreign key
relations refer to UNIQUE columns that are no primary key columns.
Example:
CREATE TABLE TAB1 (
COL1 INTEGER NOT NULL,
COL2 INTEGER NOT NULL,
CONSTRAINT PK1 PRIMARY KEY (COL1),
CONSTRAINT UK1 UNIQUE (COL2)
);
CREATE TABLE TAB2 (
COL3 INTEGER,
COL4 INTEGER,
CONSTRAINT FK1 FOREIGN KEY (COL3) REFERENCES TAB1 (COL1),
CONSTRAINT FK2 FOREIGN KEY (COL4) REFERENCES TAB1 (COL2)
);
"FK1" is shown in the explorer view, while "FK2" is missing.
I noticed that the method DatabaseMetaData.getImportedKeys(), which
would return both foreign key relations, is never called in the source
code of M3 that I downloaded.
I have opened a bug report (125003) for this issue. (I know, that it may
be the wrong order to do this: opening a bug report first and asking the
newsgroup thereafter...)
Do you also think it is a bug, or are you saying "Data Source Explorer"
works as designed?
Regards,
Johannes Lebek
|
|
|
| Re: Some foreign keys are not shown [message #8061 is a reply to message #7994] |
Thu, 26 January 2006 14:58  |
| Eclipse User |
|
|
|
Originally posted by: john.graham.sybase.com
Johannes Lebek wrote:
> Hi there,
> I have noticed that some foreign key relations are not shown in the
> "Data Source Explorer" view (M3, Jan 20). The missing foreign key
> relations refer to UNIQUE columns that are no primary key columns.
<snip>
> I have opened a bug report (125003) for this issue. (I know, that it may
> be the wrong order to do this: opening a bug report first and asking the
> newsgroup thereafter...)
> Do you also think it is a bug, or are you saying "Data Source Explorer"
> works as designed?
> Regards,
> Johannes Lebek
Hi Johannes,
Yes, we believe this is a bug in the content provider for generic JDBC,
and will be looking into it during the DTP 0.7 endgame.
Thanks for taking the time to investigate and report this!
Regards,
John Graham
Eclipse Data Tools Platform PMC
|
|
|
| Re: Some foreign keys are not shown [message #570315 is a reply to message #7994] |
Thu, 26 January 2006 14:58 |
 John Graham
Messages: 183
Registered: July 2009 |
Senior Member |
|
|
Johannes Lebek wrote:
> Hi there,
> I have noticed that some foreign key relations are not shown in the
> "Data Source Explorer" view (M3, Jan 20). The missing foreign key
> relations refer to UNIQUE columns that are no primary key columns.
<snip>
> I have opened a bug report (125003) for this issue. (I know, that it may
> be the wrong order to do this: opening a bug report first and asking the
> newsgroup thereafter...)
> Do you also think it is a bug, or are you saying "Data Source Explorer"
> works as designed?
> Regards,
> Johannes Lebek
Hi Johannes,
Yes, we believe this is a bug in the content provider for generic JDBC,
and will be looking into it during the DTP 0.7 endgame.
Thanks for taking the time to investigate and report this!
Regards,
John Graham
Eclipse Data Tools Platform PMC
|
|
|
Powered by
FUDForum. Page generated in 0.03198 seconds
] 
Search
Help
Register
Login
Home
