You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vasiliy Sisko (JIRA)" <ji...@apache.org> on 2016/07/01 02:27:10 UTC
[jira] [Updated] (IGNITE-3394) Failed to load data from Oracle DB
with type TIMESTAMP(6)
[ https://issues.apache.org/jira/browse/IGNITE-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vasiliy Sisko updated IGNITE-3394:
----------------------------------
Attachment: IGNITE_3394_Add_conversation_oracle_timestamp_type_to_java_type.patch
> 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: Alexey Kuznetsov
> Fix For: 1.7
>
> Attachments: IGNITE_3394_Add_conversation_oracle_timestamp_type_to_java_type.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)