https://community.qlik.com/t5/Talend-Studio/resolved-Getting-an-invalid-default-value-error-with-MySQL/m-p/2342489#M110352 Hi,<BR />I have a very simple job that is reading a table from one database and loading it to another database - same table definition for the source and target.&nbsp; So far so good.&nbsp; <BR />There is a column on the table that is defined as a tinyint type in MySql with a default value of 0 and is being defined as a Boolean/boolean type in the tMap component with a default value of '0'.&nbsp; Looking at the java code (via the code tab), I see that the column (aka columnA) is defined as follows...&nbsp; `columnA` BIT default '0'.&nbsp; <BR />When the job is run, it is throwing the below error.<BR /><B>"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'columnA'".&nbsp; </B><BR />Does anyone know how to resolve what should be a pretty simple exercise?&nbsp; Do I need to add an interim casting of the column?&nbsp; Use a different column type (other than boolean/Boolean) on the tMap component for the column?<BR />Any suggestions are appreciated.<BR />Thank you.&nbsp; <BR /><BR />&nbsp; Sat, 16 Nov 2024 11:07:26 GMT Anonymous 2024-11-16T11:07:26Z https://community.qlik.com/t5/Talend-Studio/resolved-Getting-an-invalid-default-value-error-with-MySQL/m-p/2342489#M110352 Hi,<BR />I have a very simple job that is reading a table from one database and loading it to another database - same table definition for the source and target.&nbsp; So far so good.&nbsp; <BR />There is a column on the table that is defined as a tinyint type in MySql with a default value of 0 and is being defined as a Boolean/boolean type in the tMap component with a default value of '0'.&nbsp; Looking at the java code (via the code tab), I see that the column (aka columnA) is defined as follows...&nbsp; `columnA` BIT default '0'.&nbsp; <BR />When the job is run, it is throwing the below error.<BR /><B>"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'columnA'".&nbsp; </B><BR />Does anyone know how to resolve what should be a pretty simple exercise?&nbsp; Do I need to add an interim casting of the column?&nbsp; Use a different column type (other than boolean/Boolean) on the tMap component for the column?<BR />Any suggestions are appreciated.<BR />Thank you.&nbsp; <BR /><BR />&nbsp; Sat, 16 Nov 2024 11:07:26 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Getting-an-invalid-default-value-error-with-MySQL/m-p/2342489#M110352 Anonymous 2024-11-16T11:07:26Z https://community.qlik.com/t5/Talend-Studio/resolved-Getting-an-invalid-default-value-error-with-MySQL/m-p/2342490#M110353 Found my answer through this old post. &nbsp; <A href="https://jira.talendforge.org/browse/TDI-1833" rel="nofollow noopener noreferrer">https://jira.talendforge.org/browse/TDI-1833</A> Wed, 29 Jul 2015 14:20:09 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Getting-an-invalid-default-value-error-with-MySQL/m-p/2342490#M110353 Anonymous 2015-07-29T14:20:09Z