Support ForumSupport Forum

Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Links not appearing in Reference Graph

Welcome, Guest: Login / Register; Guest Settings

This question is not answered. Helpful answers available: 2. Correct answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 6 - Pages: 1 - Last Post: Jul 29, 2010 8:53 PM Last Post By: Steve Jakob

Spike Oliver

Posts: 3
Registered: 07/09/10

Links not appearing in Reference Graph
Posted: Jul 9, 2010 7:20 PM

Hello Everyone,

I am new to DbVisualizer and just found the reference tool which is great, but I can not see the links between the tables. I am on a Progress database and connected to DbVisualizer through a JDBC/ODBC Bridge...Is there something else that I need to do on my end - is this because of the connection that I am using? Any help would be appreciated!

Thank you,
Spike

Hans Bergsten

Posts: 497
Registered: 10/11/06

Re: Links not appearing in Reference Graph
Posted: Jul 9, 2010 9:00 PM

in response to: Spike Oliver

Hi Spike,

The References graph shows links between tables based on declared referential integrity constraints (Primary and Foreign Keys), so please first make sure that your tables have those constraints.

I also recommend that you use a pure JDBC driver instead of the JDBC/ODBC Bridge driver, since the bridge driver is not intended for production use and has all kinds of limitations.

Best Regards,
Hans

Spike Oliver

Posts: 3
Registered: 07/09/10

Re: Links not appearing in Reference Graph
Posted: Jul 9, 2010 9:23 PM

in response to: Spike Oliver

DbVis Reference.jpg (94.2 KB )

Hi Hans,
Thank you so much for your reply - the primary and foreign keys are set up so I am scratching my head why it isn't working? I have attached a picture that shows the primary keys set up but the check box for Links to Columns is grayed out?? Thank you so much for the advice on the driver I will download the jdbc driver for progress.
Thanks again!

Hans Bergsten

Posts: 497
Registered: 10/11/06

Re: Links not appearing in Reference Graph
Posted: Jul 9, 2010 11:32 PM

in response to: Spike Oliver

Hi Spike,

The Links to Columns option is only enabled when you chose Columns as the Node Content (and only for some layouts, e.g. Hierarchic), but you should still see the links between tables. Please let us know if using the pure JDBC driver solves the problem.

Best Regards,
Hans

Spike Oliver

Posts: 3
Registered: 07/09/10

Re: Links not appearing in Reference Graph
Posted: Jul 12, 2010 3:23 PM

in response to: Spike Oliver

Hello again Hans,

Thank you again for all of your assistance! I have been looking for a Pure JDBC driver for Progress 10.1B02 with not too much luck - any recommendations? Would you recommend SequeLink?

Thanks again!

Hans Bergsten

Posts: 497
Registered: 10/11/06

Re: Links not appearing in Reference Graph
Posted: Jul 12, 2010 7:55 PM

in response to: Spike Oliver

Hi Spike,

I'm sorry, I have no experience with Progress. I suggest you ask for advice in their user forum.

Best Regards,
Hans

Steve Jakob

Posts: 17
Registered: 10/01/06

Re: Links not appearing in Reference Graph
Posted: Jul 29, 2010 8:53 PM

in response to: Spike Oliver

Spike Oliver wrote:
Hi Hans,
Thank you so much for your reply - the primary and foreign keys are set up so I am scratching my head why it isn't working? I have attached a picture that shows the primary keys set up but the check box for Links to Columns is grayed out?? Thank you so much for the advice on the driver I will download the jdbc driver for progress.

Progress is an object database (ODBMS), not a relational database (RDBMS). As such, it may not report referential constraints in the same way, especially when using the ODBC bridge. As suggested, a pure JDBC driver may provide a pseudo-relational view of the database.

Pages: 1

Back to Thread List