[OS-JIRA] Created: (CAY-182) Getting FK relationships Causes Exception

From: jir..bjectstyle.org
Date: Mon Aug 16 2004 - 12:40:46 EDT

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-183) Adapter for Clouscape/Derby DB"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-182

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-182
        Summary: Getting FK relationships Causes Exception
           Type: Bug

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 CayenneModeler GUI

       Assignee: Andrus Adamchik
       Reporter: Joe McDaniel

        Created: Mon, 16 Aug 2004 12:39 PM
        Updated: Mon, 16 Aug 2004 12:39 PM
    Environment: Sybase only?

    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

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira



    This archive was generated by hypermail 2.0.0 : Mon Aug 16 2004 - 12:40:47 EDT