can not load "0000" year values

[sekertu]

Hi all,

I use Talend Open Studio data integration 7.3. version.

I am trying to load data from mysql database and I am using tDBInput(

MySQL)

component.

I have a field named dt_birthdate and it has 10 rows like below:

I want to load data AS IT IS, but when I run the job it starts to load and then I get error like below.

I doesn't allow me to load these 10 rows. source and data field types are both date.

Could you please help me on this issue?

Thank you in advance.

Tugba

[Prakhar1]

try to change data type as dynamic in Schema

[sekertu]

Hi Prakhar, thanks for your answer,

Would you please explain more? I am not able to understand.

Do you mean tDBInput/Schema?

[sekertu]

@prakhar dubey​ 

[pakapi_]

Hi sekertu,

please paste here your tDbInput query and schema tab.

[sekertu]

Hi @Kamil Kowalczyk​ ,

my query is basic select query, datetype of dt_birthdate field is date, DBType is timestamp and pattern is "dd-MM-yyyy"

Target table's dt_birthdate field also has the date dateType.

Thanks

[cadap]

Change the Date-Pattern of the column to something like "dd.MM.'0000 00:00:00'" or change the type to String and do the translation to a java Date type later manually by using SimpleDateTimeFormatter.

[Prakhar1]

Yes the tDBInput component in which you have created a schema for known columns. If you are using paid version of Talend then you can see on data type their is an option for "dynamic". you can try it .

[Pri_passion]

I am not sure , but try passing "noDatetimeStringSync=true" to your advance setting>JDBC parameter.

[pakapi_]

Please paste here your tDbInput query. You can blur table name, or change column names to samples. This error is connected with you query. I don't see it so I cannot help.