I am currently trying to read some data in an Oracle db where I have a field that generates some problems with the new DB Labs connector. According to what I see in SQL Developper, the problematic field is EVENT_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE It shows without problem there: [image] What I get when I am trying to read with the latest Oracle DB connector is the following error message: WARN DB Table Selector (Labs) 3:48 Error during fetching data from the database: java.lang.IllegalArgumentException: Type:-101 is not a valid Types.java value. WARN DB Table Selector (Labs) 3:48 java.lang.IllegalArgumentException: Type:-101 is not a valid Types.java value. With the “official” database connector (with the latest Oracle jdbc driver), I get the following [image] I found some related material on the forum but it is concerning the “official” database connector and I would like to use the DB Labs connector which is much faster. [image] Display of Oracle Timestamp s KNIME Analytics Platform Dear all, I'm accessing an Oracle DB (11.2.0) Table with a timestamp field. The timestamps in the Oracle SQL developer are displayed like: 16.07.14 21:43:48,424000000 +02:00 Colum Format TIMESTAMP(9) WITH TIME ZONE strangely KNIME (v 2.10.3) displays the timestamp values like oracle.sql.TIMESTAMPTZ@13cdd302 Did anyone encounter this, are there any options to change it ? Can someone help me? Thanks in advance for your support. Regards, Sébastien

Problems with Oracle TIMESTAMPTZ (with timezone)

szawadski June 13, 2019, 3:19pm 2

@ipazin, @tobias.koetter
This is similar to a problem you solved previously (wrong Oracle data types mapping). Could be of interest to you.

Regards