[OS-JIRA] Created: (CAY-374) Generate explicit error message instead of silently ignoring lack of support for Generated columns

From: jira-norepl..bjectstyle.org
Date: Mon Sep 12 2005 - 13:49:38 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: Patch for CAY-360"

    Message:

      A new issue has been created in JIRA.

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

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

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-374
        Summary: Generate explicit error message instead of silently ignoring lack of support for Generated columns
           Type: Improvement

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Versions:
                 1.2 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Øyvind Harboe

        Created: Mon, 12 Sep 2005 1:49 PM
        Updated: Mon, 12 Sep 2005 1:49 PM

    Description:
    There are lots of things that can go wrong when trying to get the generated columns support to work. Good error messages would be effective in putting the developer on the right track.

    Examples of mistakes:

    - Incorrectly select org.objectstyle.cayenne.dba.JdbcAdapter
      instead of org.objectstyle.cayenne.dba.sqlserver.SQLServerAdapter

    - Accidentlly leaving the old JDBC drivers around. Often the
      developer environment is different than the production environment,
      so silent handling and subsequent cryptic error messages result.

    Basically there is a need to distinguish between two cases:

    - The developer MUST have generated column support(e.g. legacy
      databases). Here error messages are approperiate.
    - The developer wants generated column support *if it is available*.

    How to fix?

    Unpondered suggestion #1: Perhaps switch generated columns flag in the XML file to be a tristate choice?

    - Do not use generated column support
    - Always use generated column support and generate error message if
      it is not supported by either the JDBC driver, adapter or
      database
    - Use generated column support if available in database AND
      

    Unpondered suggestion #2: add flags to Cayenne XML model to handle various error situations in different ways. "Silently fall back to Cayenne primary key support when generated columns are not supported by database/JDBC driver/adapter"

    ---------------------------------------------------------------------
    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 Sep 12 2005 - 13:49:38 EDT