https://community.qlik.com/t5/Talend-Studio/Error-with-tMySQLOutput-cannot-be-null-error/m-p/2248136#M33084 An empty string will be treated as null. You should use a significant char as null replacement or remove the not null constraint. Sat, 08 Mar 2014 20:45:44 GMT Anonymous 2014-03-08T20:45:44Z https://community.qlik.com/t5/Talend-Studio/Error-with-tMySQLOutput-cannot-be-null-error/m-p/2248135#M33083 Hello, <BR />I am a Talend newbie. <BR />I am working at modifying an existing job. I changed the schema of some of the tables in the job. Now, I am trying to run the job against the newly created table schema in the database. <BR />When I run the job that's pointing to the new tables, I get an error on the first tMySQLOutput component: <BR />java.sql.BatchUpdateException: Column 'Album' cannot be null <BR />All the columns of the table in the database are NOT NULL DEFAULT ''; <BR />I also added logic to my tMaps that are feeding into this table: out1.Album==null ? "": out1.Album <BR />Using this logic, shouldn't the tMap convert the Album field to empty string if it is a null value? Not sure why the tMySQLOutput component is barking at my configuration. <BR />Can someone please assist? <BR />Best, <BR />zs Sat, 08 Mar 2014 18:32:40 GMT https://community.qlik.com/t5/Talend-Studio/Error-with-tMySQLOutput-cannot-be-null-error/m-p/2248135#M33083 _AnonymousUser 2014-03-08T18:32:40Z https://community.qlik.com/t5/Talend-Studio/Error-with-tMySQLOutput-cannot-be-null-error/m-p/2248136#M33084 An empty string will be treated as null. You should use a significant char as null replacement or remove the not null constraint. Sat, 08 Mar 2014 20:45:44 GMT https://community.qlik.com/t5/Talend-Studio/Error-with-tMySQLOutput-cannot-be-null-error/m-p/2248136#M33084 Anonymous 2014-03-08T20:45:44Z