ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 胡永亮/Bob <hu...@neusoft.com>
Subject Re: Re: argument type mismatch of oracle TIMESTAMP field when call loadCache
Date Wed, 29 Jun 2016 00:34:58 GMT
sorry, the infomation is not in detail.

My ignite's version is new release version: 1.6.



胡永亮
 
Bob
 
From: Vasiliy Sisko
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-yl@neusoft.com <hu-yl@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
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
Mime
View raw message