I have a simple job for truncating a mysql table before loading with bulk function.
I use tMysqlRow with the query "truncate table mytable".
No error shows up but by table is not truncated.
I tried to force commit using "Commit every"=1.
Even tried "truncate table mytable;commit;" but no chance.
Using the command line tool mysql, same user, host, database, the truncate statment works perfectly.
Any idea ?
Maybe add a check box on the bulk loading component "truncate before loading" ?
I assume that you have a 2.0.0 version.
This is a bug on Java tDBRow components which have been reported and corrected a few weeks ago.
Yopu can either upgrade (current version is 2.0.2) or follow instructions in http://www.talendforge.org/forum/viewtopic.php?id=604 (it's for tOracleRow but it's the same problem)
Truncate option will be added to Java DB Components in version 2.1 ([Bug] 1102)