Error with tMysqlBulkExec component

One Star

Error with tMysqlBulkExec component

I get the error below when running a job using tMysqlBulkExec.
Everything seems to be correctly setup.
I use MySQL 5.6 as database server.
Thank you.
Exception in component tMysqlBulkExec_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-bulk FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED ' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(
at com.mysql.jdbc.Util.getInstance(
at com.mysql.jdbc.SQLError.createSQLException(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.sendCommand(
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
at com.mysql.jdbc.ConnectionImpl.execSQL(
at com.mysql.jdbc.ConnectionImpl.execSQL(
at com.mysql.jdbc.StatementImpl.execute(
at com.mysql.jdbc.StatementImpl.execute(
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.tMysqlBulkExec_1Process(
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.tRowGenerator_1Process(
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.runJobInTOS(
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.main(
One Star

Re: Error with tMysqlBulkExec component

I have identified the issue:
The target table name was containing "-" .
I suppressed this one and everything went fine.
Having said that , maybe an enhancement should be made to cope with this issue.
Thank you

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.