Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@continuum.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: 
 <10507745.1237854253826.JavaMail.haus-jira@codehaus01.managed.contegix.com>
Date: Mon, 23 Mar 2009 19:24:13 -0500 (CDT)
From: "Maria Catherine Tan (JIRA)" <jira@codehaus.org>
To: issues@continuum.apache.org
Subject: [jira] Assigned: (CONTINUUM-2147) Schema generated is incorrect
 when jpox.null-value="default" is set in sendOnScmFailure field
In-Reply-To: 
 <7188070.1237854133382.JavaMail.haus-jira@codehaus01.managed.contegix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


     [ http://jira.codehaus.org/browse/CONTINUUM-2147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maria Catherine Tan reassigned CONTINUUM-2147:
----------------------------------------------

    Assignee: Maria Catherine Tan

> Schema generated is incorrect when jpox.null-value="default" is set in sendOnScmFailure field
> ---------------------------------------------------------------------------------------------
>
>                 Key: CONTINUUM-2147
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-2147
>             Project: Continuum
>          Issue Type: Bug
>          Components: Database
>    Affects Versions: 1.3.2
>            Reporter: Maria Catherine Tan
>            Assignee: Maria Catherine Tan
>             Fix For: 1.3.3
>
>
> jpox.null-value="default" in a boolean field causes:
> 1.) With MySQL, you won't be able to create and upgrade your database from Continuum 1.2.x to 1.3.x
> ERROR JPOX.RDBMS  - Error thrown executing CREATE TABLE `PROJECTNOTIFIER`
> (
>     `ID` INTEGER NOT NULL,
>     `ENABLED` BIT NOT NULL,
>     `NOTIFIERORIGIN` INTEGER NOT NULL,
>     `MODEL_ENCODING` VARCHAR(255) BINARY NULL,
>     `RECIPIENT_TYPE` INTEGER NOT NULL,
>     `SEND_ON_ERROR` BIT NOT NULL,
>     `SEND_ON_FAILURE` BIT NOT NULL,
>     `SEND_ON_SCM_FAILURE` BIT NOT NULL DEFAULT 'false',
>     `SEND_ON_SUCCESS` BIT NOT NULL,
>     `SEND_ON_WARNING` BIT NOT NULL,
>     `NOTIFIERTYPE` VARCHAR(255) BINARY NULL,
>     PRIMARY KEY (`ID`)
> ) ENGINE=INNODB : Invalid default value for 'SEND_ON_SCM_FAILURE'
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Invalid default value for 'SEND_ON_SCM_FAILURE'
> 2.) With Derby, you'll be able to create your database but it fails when you try to upgrade from continuum 1.2.x to 1.3.x
> ERROR JPOX.RDBMS  - Error thrown executing ALTER TABLE PROJECTNOTIFIER ADD SEND_ON_SCM_FAILURE CHAR(1) DEFAULT 'false' CHECK (SEND_ON_SCM_FAILURE IN ('Y','N')) : A truncation error was encountered trying to shrink CHAR 'false' to length 1.
> ERROR 22001: A truncation error was encountered trying to shrink CHAR 'false' to length 1.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira