[resolved] Exception in component tMysqlOutput_1

One Star

[resolved] Exception in component tMysqlOutput_1

hen i try to excecute my job i have this error:
Exception in component tMysqlOutput_1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Column was set to data type implicit default; NULL supplied for NOT NULL column 'id_region' at row 27.
i dont know why.
thinks for help

Accepted Solutions
Community Manager

Re: [resolved] Exception in component tMysqlOutput_1

Hello
Add more length to column and don't insert null value into a not null column, so if the column is defined as not null, you should fiter the null rows.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] Exception in component tMysqlOutput_1

Hello
Add more length to column and don't insert null value into a not null column, so if the column is defined as not null, you should fiter the null rows.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business