[resolved] Problem to map column date with 2 tables in Oracle 8

[Anonymous]

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.

[Anonymous]

Hi,
In oracleOutput component -> advanced settings
uncheck checkbox against "Use Timestamp for Date types"
Anupam

[Anonymous]

Hello,
I try your suggestion and I have this error:
ORA-00904: Nom de colonne non valide (i use TOS french) it seems that the column date format is invalid
This is a snapshot of error:

This is the format data source in toad:

and this is the format of the output in toad:

[Anonymous]

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.

[Anonymous · Accepted solution]

Excuse me, I have an error for image upload.
So, the error is causing by the column Id that you are telling but not in column date!
My problem is resolve.
Thanks for your help