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

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

Anonymous — Sat, 16 Nov 2024 11:45:20 GMT

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

Anonymous — Wed, 12 Feb 2014 19:28:49 GMT

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

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

Anonymous — Thu, 13 Feb 2014 09:30:12 GMT

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

Anonymous — Thu, 13 Feb 2014 17:53:12 GMT

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.

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

Anonymous — Fri, 14 Feb 2014 08:30:38 GMT

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