One Star

[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.
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

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

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
4 REPLIES

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

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

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

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:

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.
One Star

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

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