Hello Bob.
We create issue to fix that problem. You can watch it on page: https://issues.apache.org/jira/browse/IGNITE-3394 On Wed, Jun 29, 2016 at 7:34 AM, 胡永亮/Bob <hu...@neusoft.com> wrote: > sorry, the infomation is not in detail. > > My ignite's version is new release version: 1.6. > > ------------------------------ > 胡永亮 > > Bob > > > *From:* Vasiliy Sisko <vsi...@gridgain.com> > *Date:* 2016-06-28 19:18 > *To:* user@ignite.apache.org > *Subject:* Re: Re: argument type mismatch of oracle TIMESTAMP field when > call loadCache > Hello Bob. > > What version of Ignite are you use? > > On Tue, Jun 28, 2016 at 12:01 PM, hu...@neusoft.com <hu...@neusoft.com> > wrote: > >> hi， Alexey >> >> First, thanks your reply. >> >> My oracle version is 12.1.0.1.0, the ddl script is the following: >> >> CREATE TABLE "UIGNITE"."KC21" >> ( "AKB020" VARCHAR2(20) NOT NULL ENABLE, >> "AKC190" VARCHAR2(24) NOT NULL ENABLE, >> "AAC001" NUMBER(20,0) NOT NULL ENABLE, >> "AAZ500" VARCHAR2(50), >> "AKA130" VARCHAR2(3) NOT NULL ENABLE, >> "AAB001" NUMBER(20,0), >> "AKA101" VARCHAR2(3), >> "BKC192" TIMESTAMP (6), >> "AKC193" VARCHAR2(50), >> "BKC231" VARCHAR2(300), >> "BKC194" TIMESTAMP (6), >> "AKC195" VARCHAR2(3), >> "AKC196" VARCHAR2(50), >> "BKC232" VARCHAR2(300), >> "BKC317" VARCHAR2(3), >> "AKA151" FLOAT(126), >> "AKC021" VARCHAR2(3), >> "BKC021" VARCHAR2(3), >> "BKC197" VARCHAR2(3), >> "BKC120" VARCHAR2(3), >> "BKC128" VARCHAR2(3), >> "BKC126" VARCHAR2(3), >> "BAE073" VARCHAR2(16), >> "AKE013" VARCHAR2(3), >> "BKC023" VARCHAR2(3), >> "AAA027" VARCHAR2(6), >> "BKC378" VARCHAR2(50), >> "BKC379" VARCHAR2(50), >> "BKC380" VARCHAR2(50), >> "BKC381" VARCHAR2(50), >> "AAB034" VARCHAR2(16), >> "BAC888" VARCHAR2(16), >> "AAB301" VARCHAR2(16), >> "BKC390" VARCHAR2(20), >> "BKC500" VARCHAR2(30), >> "BKA130" VARCHAR2(3), >> "AKB021" VARCHAR2(200), >> "BKF050" VARCHAR2(20), >> "AKC273" VARCHAR2(50), >> "AKF002" VARCHAR2(100), >> "AMC020" TIMESTAMP (6), >> "AKE021" VARCHAR2(20), >> "AKE020" VARCHAR2(20), >> "BKC191" VARCHAR2(20), >> "BKC190" VARCHAR2(20), >> "AAE017" VARCHAR2(50), >> "AAE032" TIMESTAMP (6), >> "AAC999" VARCHAR2(16), >> "AAE135" VARCHAR2(20), >> "AAC003" VARCHAR2(50), >> "AAC004" VARCHAR2(3), >> "BAE450" NUMBER(20,0), >> "AAB999" VARCHAR2(16), >> "AAB004" VARCHAR2(500), >> "AAB019" VARCHAR2(3), >> "AAB020" VARCHAR2(3), >> "BKC233" VARCHAR2(2048), >> "BAE013" VARCHAR2(100), >> "BKC319" VARCHAR2(3), >> "AAE013" VARCHAR2(200), >> "BKC050" VARCHAR2(3), >> "BKC051" VARCHAR2(3), >> "BKC052" VARCHAR2(200), >> "BKC053" VARCHAR2(200), >> "BKC054" VARCHAR2(200), >> "BAZ001" NUMBER(20,0), >> "BAZ002" NUMBER(20,0), >> "BZE011" VARCHAR2(50), >> "BZE036" TIMESTAMP (6), >> "AAE011" VARCHAR2(50), >> "AAE036" TIMESTAMP (6), >> "AAE100" VARCHAR2(3), >> "BKC055" VARCHAR2(3), >> "BKC056" VARCHAR2(3), >> "BKC057" VARCHAR2(3), >> "BKC058" VARCHAR2(3), >> "BKB010" VARCHAR2(3), >> "BKB011" VARCHAR2(3), >> "BKC059" VARCHAR2(50), >> "BKC060" FLOAT(126), >> "BKC280" VARCHAR2(50), >> "BKC281" VARCHAR2(50), >> "BKC282" VARCHAR2(50), >> "BKC283" VARCHAR2(50), >> "BKC284" VARCHAR2(50), >> "BKE160" VARCHAR2(3), >> "BKE161" VARCHAR2(50), >> "BKE162" TIMESTAMP (6), >> "BKC401" VARCHAR2(3), >> "BKC285" VARCHAR2(300), >> "BKC286" VARCHAR2(300), >> "BKC287" VARCHAR2(100), >> "BKC288" VARCHAR2(200), >> "BKC289" VARCHAR2(50), >> "BKC290" VARCHAR2(50), >> "BKC291" FLOAT(126), >> "BKC292" FLOAT(126), >> "BAB024" VARCHAR2(200), >> "AAE009" VARCHAR2(200), >> "AAE010" VARCHAR2(200), >> CONSTRAINT "pk_kc21" PRIMARY KEY ("AKB020", "AKC190") >> USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS >> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 >> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 >> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) >> TABLESPACE "IGNITE" ENABLE >> ) SEGMENT CREATION IMMEDIATE >> PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 >> NOCOMPRESS LOGGING >> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 >> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 >> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) >> TABLESPACE "IGNITE" >> >> ------------------------------ >> 胡永亮 >> >> bob >> >> >> *From:* Alexey Kuznetsov <akuznet...@gridgain.com> >> *Date:* 2016-06-28 10:50 >> *To:* user@ignite.apache.org >> *Subject:* Re: argument type mismatch of oracle TIMESTAMP field when >> call loadCache >> Hi, Bob! >> >> Could post here a sample table script that help us to reproduce the >> problem? >> Something like "create table test (....)". >> >> Also, just in case please specify your Oracle version. >> >> Thanks! >> >> -- >> Alexey Kuznetsov >> >> > > > -- > Vasiliy Sisko > GridGain Systems > www.gridgain.com > > -- Vasiliy Sisko GridGain Systems www.gridgain.com
