[CAY-182] Getting FK relationships Causes Exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1 [LEGACY]
• Component/s: Modeler
• Environment: Sybase only?
• Assignee: Andrus Adamchik
• Reporter: Joe McDaniel
• Created: 16/Aug/04 19:39
• Updated: 20/Dec/04 18:28
• Resolved: 24/Aug/04 23:06

Description

In BdLoader, loadDbRelationships,

(line 460) ResultSet rs =
getMetaData().getExportedKeys(
pkEntity.getCatalog(),
pkEntity.getSchema(),
pkEntity.getName());

will cause an exception to be thrown for (I think just) views. There are a couple of possible fixes – one can put a try/catch aroung the above statement and check the error for something other than "No such object or user exists in the database" (may be Sybase specific) or Skip all views or skip all tables with no primary keys. (Not sure which if any of these are good fixes.)

Joe