[resolved] Getting an 'invalid default value' error with MySQL tinyint.

Five Stars

[resolved] Getting an 'invalid default value' error with MySQL tinyint.

Hi,
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.  So far so good. 
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'.  Looking at the java code (via the code tab), I see that the column (aka columnA) is defined as follows...  `columnA` BIT default '0'. 
When the job is run, it is throwing the below error.
"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'columnA'". 
Does anyone know how to resolve what should be a pretty simple exercise?  Do I need to add an interim casting of the column?  Use a different column type (other than boolean/Boolean) on the tMap component for the column?
Any suggestions are appreciated.
Thank you. 

 

Accepted Solutions
Five Stars

Re: [resolved] Getting an 'invalid default value' error with MySQL tinyint.

Found my answer through this old post.   https://jira.talendforge.org/browse/TDI-1833

All Replies
Five Stars

Re: [resolved] Getting an 'invalid default value' error with MySQL tinyint.

Found my answer through this old post.   https://jira.talendforge.org/browse/TDI-1833