[resolved] [RESOLVED] - Data tuncatin: Out f ang au
Hello I don't understand, I have this message : com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'nb_entrees' at row 1 But it arrives after 54700 lines loaded (on a theoric 95000)... This job was working good yesterday... Is it possible to identify the input line which could provoque this error ? this input data is a double 17,17 and the output is like that too...
OH MY GOD !!!! the problem that I had defined the double (17,17)... that mean 17 digits and 17 décimals so it rests 0 for the interger!!!!!! with double(24;12) everuthing is OK I was getting really crazy... Now I'm crying... I've destroyed 17523 walls with my head just for that... I'm stupid! Sorry!
