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 Fri, 01 Jul 2016 00:19:17 GMT
hello,  Vasiliy

        I saw the issue, the status is the following:

        Status: Patch Available

        But, I check the code in the github: https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/cache/store/jdbc/CacheAbstractJdbcStore.java


        The related code was not changed for fixing this bug.

        I want to know, how can I get the code patch?

        thanks.



胡永亮
 
Bob
 
From: Vasiliy Sisko
Date: 2016-06-29 15:37
To: user@ignite.apache.org
Subject: Re: Re: argument type mismatch of oracle TIMESTAMP field when call loadCache
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-yl@neusoft.com> wrote:
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



-- 
Vasiliy Sisko
GridGain Systems
www.gridgain.com


---------------------------------------------------------------------------------------------------
Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s)
is intended only for the use of the intended recipient and may be confidential and/or privileged
of
Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication
is
not the intended recipient, unauthorized use, forwarding, printing,  storing, disclosure or
copying
is strictly prohibited, and may be unlawful.If you have received this communication in error,please
immediately notify the sender by return e-mail, and delete the original message and all copies
from
your system. Thank you.
---------------------------------------------------------------------------------------------------
Mime
View raw message