ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Konstantinov (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (IGNITE-1158) Duplicate Field when creating using Apache Ignite Schema Import utility
Date Fri, 31 Jul 2015 10:30:06 GMT

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

Pavel Konstantinov closed IGNITE-1158.
--------------------------------------
    Assignee:     (was: Pavel Konstantinov)

> Duplicate Field when creating using Apache Ignite Schema Import utility
> -----------------------------------------------------------------------
>
>                 Key: IGNITE-1158
>                 URL: https://issues.apache.org/jira/browse/IGNITE-1158
>             Project: Ignite
>          Issue Type: Bug
>          Components: general
>    Affects Versions: 1.1.4
>            Reporter: Alexey Kuznetsov
>             Fix For: ignite-1.4
>
>         Attachments: CacheConfig.java, ExceptionMaster.java, ExceptionMasterKey.java,
ignite-1.3.3_ignite-1158.patch, ignite-type-metadata.xml
>
>
> I am creating the cache using Apache Ignite Schema Import utility.  But it
> is generating me duplicate fields for my values.
> public class ModelFieldStaticdata implements Serializable {
>     /** */
>     private static final long serialVersionUID = 0L;
>     /** Value for modelFieldStaticdataOid. */
>     private java.math.BigDecimal modelFieldStaticdataOid;
>     /** Value for modelFieldStaticdataOid. */
>     private java.math.BigDecimal modelFieldStaticdataOid;
>     /** Value for modelFieldStaticdataOid. */
>     private java.math.BigDecimal modelFieldStaticdataOid;
>     /** Value for modelFieldStaticdataOid. */
>     private java.math.BigDecimal modelFieldStaticdataOid;
>     /** Value for modelFieldStaticdataOid. */
>     private java.math.BigDecimal modelFieldStaticdataOid;
>     /** Value for modelFieldStaticdataOid. */
>     private java.math.BigDecimal modelFieldStaticdataOid;
> I am using oracle sql developer 4.1.1.19 and the driver is ojdbc 6.1. The
> script to create table is as follows
> CREATE TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER"
>    (    "EXCEPTION_ID" VARCHAR2(100 CHAR),
>         "EXCEPTION_CREATED_DATE" DATE,
>         "EXCEPTION_PROCESSING_DATE" DATE,
>         "EXCEPTION_COMPLETION_DATE" DATE,
>         "EXCEPTION_PRIORITY" VARCHAR2(30 CHAR),
>         "EXCEPTION_SEVERITY" VARCHAR2(30 CHAR),
>         "GEOGRAPHY_ID" NUMBER(30,0),
>         "COUNTRY_ID" NUMBER,
>         "BRANCH_ID" NUMBER,
>         "L1L2STATUS" VARCHAR2(50 CHAR),
>         "SERVICE_LEVEL" VARCHAR2(100 CHAR),
>         "RECONCILIATION_TYPE" VARCHAR2(30 CHAR),
>         "UPDATED_BY" VARCHAR2(30 CHAR),
>         "UPDATED_DATE" TIMESTAMP (6),
>         "SESSION_ID" VARCHAR2(80 BYTE),
>         "RECORD_END_DATE" TIMESTAMP (6),
>         "RECORD_STATUS" VARCHAR2(10 CHAR),
>         "CREATED_DATE" TIMESTAMP (6),
>         "EXCEPTION_CATEGORY" VARCHAR2(32 BYTE),
>         "EXCEPTION_DESCRIPTION" VARCHAR2(180 BYTE),
>         "EXCEPTION_OID" NUMBER(30,0),
>         "EXCEPTION_STATUS" VARCHAR2(32 BYTE),
>         "EXCEPTION_TYPE_ID" NUMBER(30,0),
>         "FUNCTIONAL_AREA_ID" NUMBER(30,0),
>         "IPADDRESS" VARCHAR2(39 BYTE),
>         "PRODUCTLINE_ID" NUMBER(30,0),
>         "RECON_ID" VARCHAR2(32 BYTE),
>         "RECORD_VERSION" NUMBER(6,0),
>         "CREATED_BY" VARCHAR2(32 BYTE),
>         "LINK_ID" NUMBER(30,0),
>         "BUSINESS_CONTEXT_ID" VARCHAR2(32 CHAR),
>         "RECON_EXECUTION_ID" NUMBER(30,0),
>         "BUSINESS_PROCESS_ID" VARCHAR2(32 BYTE),
>         "MANUAL_ENTRY_FLAG" VARCHAR2(12 BYTE),
>         "PROCESSING_TYPE" VARCHAR2(32 BYTE),
>         "ASSET_CLASS_ID" VARCHAR2(32 BYTE),
>         "TRADE_DATE" DATE,
>         "PARENT_EXCEPTION_ID" VARCHAR2(100 BYTE),
>         "MERGED_EXCEPTION_ID" VARCHAR2(100 CHAR),
>         "GROUPED_EXCEPTION_ID" VARCHAR2(100 CHAR),
>         "EXCEPTION_GROUP_INDICATOR" VARCHAR2(10 CHAR),
>         "TOTAL_OUTSTANDING_AMOUNT" NUMBER(12,2),
>         "CLEARING_DATE" DATE,
>         "REASON_CODE" VARCHAR2(32 CHAR),
>         "COMMENTS" VARCHAR2(2000 CHAR),
>         "EXCEPTION_AUTHORIZATION_STATUS" VARCHAR2(32 CHAR),
>         "SUSPENSE_ENTRY_FLAG" VARCHAR2(10 CHAR)
>    ) SEGMENT CREATION IMMEDIATE
>   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
>   STORAGE(INITIAL 52428800 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
>   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
> FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
>   TABLESPACE "USERS" ;
> --------------------------------------------------------
> --  DDL for Index EXCEPTION_MASTER_PK
> --------------------------------------------------------
>   CREATE UNIQUE INDEX "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER_PK" ON
> "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ("EXCEPTION_OID")
>   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
>   STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
>   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
> FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
>   TABLESPACE "USERS" ;
> --------------------------------------------------------
> --  Constraints for Table EXCEPTION_MASTER
> --------------------------------------------------------
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ADD CONSTRAINT
> "EXCEPTION_MASTER_PK" PRIMARY KEY ("EXCEPTION_OID")
>   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
>   STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
>   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
> FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
>   TABLESPACE "USERS"  ENABLE;
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("EXCEPTION_ID" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("RECORD_STATUS" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("CREATED_DATE" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("EXCEPTION_OID" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("EXCEPTION_STATUS" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("IPADDRESS"
> NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("RECORD_VERSION" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("CREATED_BY"
> NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("LINK_ID"
> NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("BUSINESS_CONTEXT_ID" NOT NULL ENABLE);
>   ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
> ("RECON_EXECUTION_ID" NOT NULL ENABLE);
> --------------------------------------------------------
> --  DDL for Trigger EXCEPTION_OID_TRIGGER
> --------------------------------------------------------
>   CREATE OR REPLACE TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER"
> before
> INSERT ON "EXCEPTION_MASTER" FOR EACH row BEGIN IF inserting THEN
> SELECT EXCEPTION_MASTER_SEQ.nextval INTO :NEW."EXCEPTION_OID" FROM dual;
> END IF;
> END;
> /
> ALTER TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER" DISABLE;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message