[resolved] Problem to map column date with 2 tables in Oracle 8
Hello, Why talend (TOS 5.4) convert automatically a date column to timestamp in oracle 8. I have this error when i try to mapping 2 tables having date column in oracle 8: Exception in component tOracleOutput_1 java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date.
Re: [resolved] Problem to map column date with 2 tables in Oracle 8
ORA-00904 is about invalid column name. I don't see ID_DATE column in screenshot you gave "Could you please validate the schema on Tdata output component and make sure it has all the columns you are trying to insert and with correct names.