• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Exception in component tMysqlOutput_1

#1 2009-09-18 15:50:35

magui_laurene
New member
Registered: 2009-09-10
Posts: 2

[resolved] Exception in component tMysqlOutput_1

Tags: [data, truncation]

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

Offline

#2 2009-09-21 09:40:57

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Exception in component tMysqlOutput_1

Board footer

Powered by FluxBB