Duplicate Field when creating using Apache Ignite Schema Import utility

classic Classic list List threaded Threaded
14 messages Options
krishnangc krishnangc
Reply | Threaded
Open this post in threaded view
|

Duplicate Field when creating using Apache Ignite Schema Import utility

Hi,

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;


Thanks in Advance

Krishna
Alexey Kuznetsov Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Krishna,

Thanks for your report.

Could you please provide what RDBMs  (exact name and version) your are using and SQL script to create table.
And also what JDBC driver you are using to connect to database (exact name and version).
We will try to reproduce and fix schema-import utility.

For now you could delete duplicate fields by hand in generated file.

On Fri, Jul 24, 2015 at 10:17 PM, krishnangc <[hidden email]> wrote:
Hi,

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;


Thanks in Advance

Krishna




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Duplicate-Field-when-creating-using-Apache-Ignite-Schema-Import-utility-tp709.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.



--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
krishnangc krishnangc
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Hi,

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;
Alexey Kuznetsov Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Hi, I created issue https://issues.apache.org/jira/browse/IGNITE-1158
You can track it (add to watchers).

On Fri, Jul 24, 2015 at 10:53 PM, krishnangc <[hidden email]> wrote:
Hi,

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;




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Duplicate-Field-when-creating-using-Apache-Ignite-Schema-Import-utility-tp709p711.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.



--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
Alexey Kuznetsov Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

In reply to this post by krishnangc
Krishna,

In your first post in this thread you mentioned ModelFieldStaticdata  class, but you provide later DDL for EXCEPTION_MASTER table.
Did you provide full DDL? Please recheck and post missing pieces.

--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
dsetrakyan dsetrakyan
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Alexey,

Is there any chance you can try reproducing the issue and provide proper configuration here?

As far as attaching code, I would use paste bin or GitHub Gists: 

D.

On Tue, Jul 28, 2015 at 8:44 AM, Alexey Kuznetsov <[hidden email]> wrote:
Krishna,

In your first post in this thread you mentioned ModelFieldStaticdata  class, but you provide later DDL for EXCEPTION_MASTER table.
Did you provide full DDL? Please recheck and post missing pieces.

--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com

krishnangc krishnangc
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

In reply to this post by Alexey Kuznetsov
Hi Alexey,


I have generated the DDL file again and put in pastebin the link is

http://pastebin.com/gy7VNfUf

Thanks and Regads

Krishna
krishnangc krishnangc
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

In reply to this post by Alexey Kuznetsov
Hi Alexey,

Sorry. I had tried to create POJOs for 5 tables. I had coped the wrong file. The correct one I have mailed it across to you, with all the details. Now I am trying to put only one table ExceptionMaster to cache.

Sorry,

Krishna
Alexey Kuznetsov Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Hi Krishna!

I'm a little confused by your last comment.
Is issue with duplicate fields generation is still actual?
Could you please once more provide steps to reproduce?

On Wed, Jul 29, 2015 at 12:47 PM, krishnangc <[hidden email]> wrote:
Hi Alexey,

Sorry. I had tried to create POJOs for 5 tables. I had coped the wrong file.
The correct one I have mailed it across to you, with all the details. Now I
am trying to put only one table ExceptionMaster to cache.

Sorry,

Krishna



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Duplicate-Field-when-creating-using-Apache-Ignite-Schema-Import-utility-tp709p745.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.



--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
krishnangc krishnangc
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Hi

Any updates on the issue.

Thanks and Regards

Krishna
dsetrakyan dsetrakyan
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

krishnangc wrote
Any updates on the issue.
Krishna, I understand you have exchanged some direct email with Alexey. Can I ask you to provide all the code to reproduce this issue in the ticket?
https://issues.apache.org/jira/browse/IGNITE-1158

You can attach files to the ticket directly.

D.
krishnangc krishnangc
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Hi

I have attached the files to JIRA

Thanks

Krishna
Alexey Kuznetsov Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Krishna,

We are looking into this issue.
Will provide a feedback shortly.

-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
Alexey Kuznetsov Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Field when creating using Apache Ignite Schema Import utility

Krishna, 

We reproduced and fixed this issue.
I push changes to ignite-1.3.3 branch that will be released in a couple of days.

Thanks for your bug report.


-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com