Hi,
thanks for reporting this problem. We will look into it and solve it as soon as possible. The type mapping framework uses the JDBC types as database types. According to the Oracle documentation is the Oracle type Date mapped to the JDBC type timestamp which is correctly mapped to Local Date Time. However it seems that this is not the case. Since the JDBC driver returns Date as JDBC type which is mapped to Local Date. We will investigate further and fix the problem.
Bye
Tobias
Hi,
we have identified and fixed the problem. The fix will be available with the next KNIME bug fix release. Since Oracle only supports Date and Timestamp which both return the JDBCType Timestamp we will allow user to map from timestamp to LocalDate and LocalDateTime when they are connected to an Oracle db. The default database types suggested by the DB Table Creator node for LocalDate and LocalDateTime cells is now DATE. For LocalDateTime the default type is still Timestamp. Let us know if you have found any other issues or if you have any suggestions. Thanks for testing the new database framework.
Bye
Tobias
I just donwloaded and updated Knime Analytics Platform to version 3.7.1.
The bug is indeed corrected.
Thanks a lot for taking into account our findings!