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/06/29 09:09:51 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:
----------------------------------
Description:
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}
> 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
>
>
> 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)