Return-Path: 
 <ddlutils-dev-return-1959-apmail-db-ddlutils-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org
Received: (qmail 49845 invoked from network); 12 Aug 2009 12:33:33 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 12 Aug 2009 12:33:33 -0000
Received: (qmail 64649 invoked by uid 500); 12 Aug 2009 12:33:40 -0000
Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org
Received: (qmail 64604 invoked by uid 500); 12 Aug 2009 12:33:39 -0000
Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-dev-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-dev-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-dev@db.apache.org>
List-Id: <ddlutils-dev.db.apache.org>
Reply-To: ddlutils-dev@db.apache.org
Delivered-To: mailing list ddlutils-dev@db.apache.org
Received: (qmail 64594 invoked by uid 99); 12 Aug 2009 12:33:39 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Aug 2009 12:33:39 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Aug 2009 12:33:36 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 00E42234C004
	for <ddlutils-dev@db.apache.org>; Wed, 12 Aug 2009 05:33:15 -0700 (PDT)
Message-ID: <52849406.1250080394999.JavaMail.jira@brutus>
Date: Wed, 12 Aug 2009 05:33:14 -0700 (PDT)
From: "Stefan Huber (JIRA)" <jira@apache.org>
To: ddlutils-dev@db.apache.org
Subject: [jira] Updated: (DDLUTILS-251) primary key column change causes
 exception (#2)
In-Reply-To: <1221204402.1250077454890.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/DDLUTILS-251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stefan Huber updated DDLUTILS-251:
----------------------------------

    Description: 
If you add a column to an existing primary key, database updates fails with NullPointerException:

java.lang.NullPointerException
	at org.apache.ddlutils.alteration.AddPrimaryKeyChange.apply(AddPrimaryKeyChange.java)
	at org.apache.ddlutils.platform.SqlBuilder.processChange(SqlBuilder.java)
	at org.apache.ddlutils.platform.mssql.MSSqlBuilder.processTableStructureChanges(MSSqlBuilder.java)
	at org.apache.ddlutils.platform.SqlBuilder.processTableStructureChanges(SqlBuilder.java)
	at org.apache.ddlutils.platform.SqlBuilder.processTableStructureChanges(SqlBuilder.java)
	at org.apache.ddlutils.platform.SqlBuilder.processChanges(SqlBuilder.java)
	at org.apache.ddlutils.platform.mssql.MSSqlBuilder.processChanges(MSSqlBuilder.java)
	at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(SqlBuilder.java)


Orignial table definition:

    <table name="DISPLAYNAMES">
        <column name="CLASSNAME" primaryKey="true" required="true" type="VARCHAR" size="200"
                autoIncrement="false"/>
        <column name="FIRMWAREID" primaryKey="true" required="true" type="INTEGER" size="10"
                autoIncrement="false"/>
        <column name="LANGUAGE" primaryKey="true" required="true" type="CHAR" size="5"
                autoIncrement="false"/>
        <column name="DISPLAYNAME" primaryKey="false" required="true" type="VARCHAR" size="200"
                autoIncrement="false"/>
    </table>

New table definition with additional primary key column INSTANCENR:

    <table name="DISPLAYNAMES">
        <column name="CLASSNAME" primaryKey="true" required="true" type="VARCHAR" size="200"
                autoIncrement="false"/>
        <column name="FIRMWAREID" primaryKey="true" required="true" type="INTEGER" size="10"
                autoIncrement="false"/>
        <column name="LANGUAGE" primaryKey="true" required="true" type="CHAR" size="5"
                autoIncrement="false"/>
        <column name="INSTANCENR" primaryKey="true" required="true" type="INTEGER" size="10"
                autoIncrement="false" default="-1"/>
        <column name="DISPLAYNAME" primaryKey="false" required="true" type="VARCHAR" size="1000"
                autoIncrement="false"/>
    </table>

It's a problem similar to bug DDLUTILS-159 (already resolved for Oracle, SAP DB and MySQL)

  was:
Primary key changes don't work with SQLServer database.
It's the same problem described in DDLUTILS-159 and already resolved for Oracle, SAP DB and MySQL.


> primary key column change causes exception (#2)
> -----------------------------------------------
>
>                 Key: DDLUTILS-251
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-251
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - SqlServer
>    Affects Versions: 1.0
>         Environment: Windows XP
>            Reporter: Stefan Huber
>            Assignee: Thomas Dudziak
>
> If you add a column to an existing primary key, database updates fails with NullPointerException:
> java.lang.NullPointerException
> 	at org.apache.ddlutils.alteration.AddPrimaryKeyChange.apply(AddPrimaryKeyChange.java)
> 	at org.apache.ddlutils.platform.SqlBuilder.processChange(SqlBuilder.java)
> 	at org.apache.ddlutils.platform.mssql.MSSqlBuilder.processTableStructureChanges(MSSqlBuilder.java)
> 	at org.apache.ddlutils.platform.SqlBuilder.processTableStructureChanges(SqlBuilder.java)
> 	at org.apache.ddlutils.platform.SqlBuilder.processTableStructureChanges(SqlBuilder.java)
> 	at org.apache.ddlutils.platform.SqlBuilder.processChanges(SqlBuilder.java)
> 	at org.apache.ddlutils.platform.mssql.MSSqlBuilder.processChanges(MSSqlBuilder.java)
> 	at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(SqlBuilder.java)
> Orignial table definition:
>     <table name="DISPLAYNAMES">
>         <column name="CLASSNAME" primaryKey="true" required="true" type="VARCHAR" size="200"
>                 autoIncrement="false"/>
>         <column name="FIRMWAREID" primaryKey="true" required="true" type="INTEGER" size="10"
>                 autoIncrement="false"/>
>         <column name="LANGUAGE" primaryKey="true" required="true" type="CHAR" size="5"
>                 autoIncrement="false"/>
>         <column name="DISPLAYNAME" primaryKey="false" required="true" type="VARCHAR" size="200"
>                 autoIncrement="false"/>
>     </table>
> New table definition with additional primary key column INSTANCENR:
>     <table name="DISPLAYNAMES">
>         <column name="CLASSNAME" primaryKey="true" required="true" type="VARCHAR" size="200"
>                 autoIncrement="false"/>
>         <column name="FIRMWAREID" primaryKey="true" required="true" type="INTEGER" size="10"
>                 autoIncrement="false"/>
>         <column name="LANGUAGE" primaryKey="true" required="true" type="CHAR" size="5"
>                 autoIncrement="false"/>
>         <column name="INSTANCENR" primaryKey="true" required="true" type="INTEGER" size="10"
>                 autoIncrement="false" default="-1"/>
>         <column name="DISPLAYNAME" primaryKey="false" required="true" type="VARCHAR" size="1000"
>                 autoIncrement="false"/>
>     </table>
> It's a problem similar to bug DDLUTILS-159 (already resolved for Oracle, SAP DB and MySQL)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.