You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Alexey Kuznetsov (JIRA)" <ji...@apache.org> on 2015/07/24 18:34:04 UTC
[jira] [Created] (IGNITE-1158) Duplicate Field when creating using
Apache Ignite Schema Import utility
Alexey Kuznetsov created IGNITE-1158:
----------------------------------------
Summary: 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
Assignee: Alexey Kuznetsov
Fix For: sprint-8
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)