[OS-JIRA] Created: (CAY-114) Null vs. Empty String validation

From: jir..bjectstyle.org
Date: Mon Apr 05 2004 - 00:28:07 EDT

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-115) Using DISTINCT when joining on to-many sometimes causes trouble"

    Message:

      A new issue has been created in JIRA.

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

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

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-114
        Summary: Null vs. Empty String validation
           Type: Task

         Status: Assigned
       Priority: Minor

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Fix Fors:
                 1.1 [DEV]
       Versions:
                 1.1 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Mon, 5 Apr 2004 12:27 AM
        Updated: Mon, 5 Apr 2004 12:27 AM

    Description:
    http://objectstyle.org/cayenne/lists/cayenne-devel/2004/04/0001.html

    Some DB engines (notably Oracle) can't tell the difference between NULL and "". Oracle (either at the driver level or at the DB level?) converts empty string to nulls with all the consequwnces (e.g. a DB exception when the column allows no nulls).

    This affects Cayenne validation, since in most cases validation should pass when a required field has an empty string value... In all cases except when Oracle is the target database.

    ---------------------------------------------------------------------
    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 Apr 05 2004 - 00:28:08 EDT