[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.