ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vasiliy Sisko <vsi...@gridgain.com>
Subject Re: Re: argument type mismatch of oracle TIMESTAMP field when call loadCache
Date Fri, 01 Jul 2016 02:50:07 GMT
Sorry Bob.

I forgot to attach patch to issue.

On Fri, Jul 1, 2016 at 7:19 AM, 胡永亮/Bob <hu-yl@neusoft.com> wrote:

> hello, * Vasiliy <vsisko@gridgain.com>*
>
>         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 <vsisko@gridgain.com>
> *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 <vsisko@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-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 <akuznetsov@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
>
>
>
> ---------------------------------------------------------------------------------------------------
> 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.
>
> ---------------------------------------------------------------------------------------------------
>



-- 
Vasiliy Sisko
GridGain Systems
www.gridgain.com

Mime
View raw message