Login | Register
My pages Projects Community openCollabNet

Discussions > issues > [Issue 2] New - CONSTRAINT command duplicated

argouml-db
Discussion topic

Back to topic list

[Issue 2] New - CONSTRAINT command duplicated

Author jgrengbondai
Full name Jules Grengbondai
Date 2007-11-09 06:35:33 PST
Message http://argouml-db.ti​gris.org/issues/show​_bug.cgi?id=2
                 Issue #|2
                 Summary|CONSTRAINT command duplicated
               Component|argouml-db
                 Version|current
                Platform|All
              OS/Version|All
                     URL|
                  Status|NEW
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|www
             Assigned to|issues@argouml-db
             Reported by|jgrengbondai






------- Additional comments from jgrengbondai at tigris dot org Fri Nov 9 06:35:33 -0800 2007 -------
This problem is found with release 1.0.3.

Read and respond to this message at:
https://sourceforge.​net/forum/message.ph​p?msg_id=4610810
By: nkomikawa

Hello,

The source generated has CONSTRAINT command in the CREATE TABLE and ALTER
TABLE.
I am using org.dbuml.base.facto​ry.OraFactory


/* Drop Table ISTIADM.CLASSE */

DROP TABLE ISTIADM.CLASSE cascade;

/* Drop Table ISTIADM.DIRETORIO */

DROP TABLE ISTIADM.DIRETORIO cascade;

/* Drop Table ISTIADM.XSL */

DROP TABLE ISTIADM.XSL cascade;

/* Drop Table ISTIADM.new_tbl */

DROP TABLE ISTIADM.new_tbl cascade;

/* Drop Table ISTIADM.new_tbl */

DROP TABLE ISTIADM.new_tbl cascade;

/* Drop Table ISTIADM.CONTENT_TYPE */

DROP TABLE ISTIADM.CONTENT_TYPE cascade;

/* Drop Schema ISTIADM */

drop user ISTIADM cascade;

/* Create Schema ISTIADM */

create user ISTIADM identified by ISTIADM;

grant all privileges to ISTIADM;

CREATE TABLE ISTIADM.CLASSE (

    CD_CLASSE DECIMAL(5),

    DS_CLASSE VARCHAR(85) NOT NULL,

    CONSTRAINT SYS_C009623 PRIMARY KEY (CD_CLASSE)

);

CREATE TABLE ISTIADM.DIRETORIO (

    CD_DIRETORIO DECIMAL(5),

    DS_DIRETORIO VARCHAR(50) NOT NULL,

    CD_DIRETORIO_PAI DECIMAL(5),

    TX_TESTE VARCHAR(200),

    CONSTRAINT DIRETORIO_PK PRIMARY KEY (CD_DIRETORIO)

);

CREATE TABLE ISTIADM.XSL (

    CD_XSL DECIMAL(5),

    CD_ESTADO DECIMAL(5) NOT NULL,

    NO_ARQUIVO_XSL VARCHAR(50) NOT NULL,

    CD_CLASSE DECIMAL(5),

    CD_CONTENT_TYPE DECIMAL(5),

    CD_DIRETORIO DECIMAL(5),

    DT_TEXTO DATE,

    CONSTRAINT XSL_PK PRIMARY KEY (CD_XSL),

    CONSTRAINT CONTENT_TYPE_XSL FOREIGN KEY (CD_CONTENT_TYPE) REFERENCES
ISTIADM.CONTENT_TYPE​(CD_CONTENT_TYPE)

,

    CONSTRAINT CLASSE_XSL FOREIGN KEY (CD_CLASSE) REFERENCES
ISTIADM.CLASSE(CD_CLASSE)

,

    CONSTRAINT DIR_XSL FOREIGN KEY (CD_DIRETORIO) REFERENCES
ISTIADM.DIRETORIO(CD_DIRETORIO)

 

);

CREATE TABLE ISTIADM.new_tbl (

    id int,

    tx VARCHAR,

    CONSTRAINT PRIMARY KEY ()

);

CREATE TABLE ISTIADM.new_tbl (

    id2 int,

    tx2 VARCHAR,

    CONSTRAINT PRIMARY KEY ()

);

CREATE TABLE ISTIADM.CONTENT_TYPE (

    CD_CONTENT_TYPE DECIMAL(5),

    DS_CONTENT_TYPE VARCHAR(50) NOT NULL,

    CONSTRAINT CONTENT_TYPE_PK PRIMARY KEY (CD_CONTENT_TYPE)

);

/* ALTER TABLE ISTIADM.CLASSE */

ALTER TABLE ISTIADM.CLASSE

ADD CONSTRAINT SYS_C009623 PRIMARY KEY

    (

        CD_CLASSE

    );

/* ALTER TABLE ISTIADM.DIRETORIO */

ALTER TABLE ISTIADM.DIRETORIO

ADD CONSTRAINT DIRETORIO_PK PRIMARY KEY

    (

        CD_DIRETORIO

    );

/* ALTER TABLE ISTIADM.XSL */

ALTER TABLE ISTIADM.XSL

ADD CONSTRAINT XSL_PK PRIMARY KEY

    (

        CD_XSL

    );

/* ALTER TABLE ISTIADM.CONTENT_TYPE */

ALTER TABLE ISTIADM.CONTENT_TYPE

ADD CONSTRAINT CONTENT_TYPE_PK PRIMARY KEY

    (

        CD_CONTENT_TYPE

    );



/* ALTER TABLE ISTIADM.XSL */

ALTER TABLE ISTIADM.XSL

ADD CONSTRAINT CONTENT_TYPE_XSL foreign key

    (

    CD_CONTENT_TYPE

    )

    references ISTIADM.CONTENT_TYPE

    (

     CD_CONTENT_TYPE

    )

;

/* ALTER TABLE ISTIADM.XSL */

ALTER TABLE ISTIADM.XSL

ADD CONSTRAINT CLASSE_XSL foreign key

    (

    CD_CLASSE

    )

    references ISTIADM.CLASSE

    (

     CD_CLASSE

    )

;

/* ALTER TABLE ISTIADM.XSL */

ALTER TABLE ISTIADM.XSL

ADD CONSTRAINT DIR_XSL foreign key

    (

    CD_DIRETORIO

    )

    references ISTIADM.DIRETORIO

    (

     CD_DIRETORIO

    )

;

« Previous message in topic | 1 of 2 | Next message in topic »

Messages

Show all messages in topic

[Issue 2] New - CONSTRAINT command duplicated jgrengbondai Jules Grengbondai 2007-11-09 06:35:33 PST
     [Issue 2] CONSTRAINT command duplicated jgrengbondai Jules Grengbondai 2007-12-04 13:39:11 PST
Messages per page: