[jira] [Commented] (IGNITE-3394) Failed to load data from Oracle DB with type TIMESTAMP(6)

["Vasiliy Sisko (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15374577#comment-15374577 ] 

Vasiliy Sisko commented on IGNITE-3394:
---------------------------------------

In JDBC store a separated data mapper has been added. 
Default implementation of mapper include solution for currently known issues.

> Failed to load data from Oracle DB with type TIMESTAMP(6)
> ---------------------------------------------------------
>
>                 Key: IGNITE-3394
>                 URL: https://issues.apache.org/jira/browse/IGNITE-3394
>             Project: Ignite
>          Issue Type: Bug
>          Components: cache
>    Affects Versions: 1.7
>            Reporter: Vasiliy Sisko
>            Assignee: Vasiliy Sisko
>             Fix For: 1.7
>
>         Attachments: IGNITE_3394_Add_conversation_oracle_timestamp_type_to_java_type.patch, IGNITE_3394_Added_jdbc_data_mapper_.patch
>
>
> To test:
> # Run Oracle database.
> # Create user.
> # Create table by script:
> {code}
> create table "<user_name>"."TEST" (
>   "A" INTEGER PRIMARY KEY, 
>   "B" TIMESTAMP,
>   "C" TIMESTAMP(0),
>   "D" TIMESTAMP(1),
>   "E" TIMESTAMP(2),
>   "F" TIMESTAMP(3),
>   "G" TIMESTAMP(4),
>   "H" TIMESTAMP(5),
>   "J" TIMESTAMP(6),
>   "K" TIMESTAMP(7),
>   "L" TIMESTAMP(8),
>   "M" TIMESTAMP(9)
> );
> {code}
> # Fill table by script:
> {code}
> INSERT INTO "<user_name>"."TEST" VALUES (1, 
>   TO_TIMESTAMP('10-SEP-0214:10:10','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.1','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.12','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.123','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.1234','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.12345','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.123456','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.1234567','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.12345678','DD-MON-RRHH24:MI:SS.FF'),
>   TO_TIMESTAMP('10-SEP-0214:10:10.123456789','DD-MON-RRHH24:MI:SS.FF')
> );
> {code}
> # Open Gridgain Web Console: https://console.gridgain.com/. 
> # Import model from database on Model page.
> # Create cluster on Cluster page and link with autogenerated cache.
> # Download project code on Summary page.
> # In class ServerNodeCodeStartup change code of main function to: 
> {code}
> Ignite ignite = Ignition.start(ServerConfigurationFactory.createConfiguration());
> ignite.cache("TestCache").loadCache(null);
> {code}
> # Run node by using ServerNodeCodeStartup.main function.
> - Node should run without exceptions.
> # Return to GridGain Web Console and go to SQL page.
> # Execute query for data extraction from TestCache cache,  f.e: 
> {code}
> Select b,d,f,h,k,m FROM "TestCache".Test
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)