[ https://issues.apache.org/jira/browse/IGNITE-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15378987#comment-15378987 ]
Pavel Konstantinov commented on IGNITE-3394: -------------------------------------------- Ilya, could you please build staging from the branch ignite-3394. > 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: Pavel Konstantinov > 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} > http://apache-ignite-users.70518.x6.nabble.com/argument-type-mismatch-of-oracle-TIMESTAMP-field-when-call-loadCache-td5935.html -- This message was sent by Atlassian JIRA (v6.3.4#6332)