Error with tMysqlBulkExec component

One Star

Error with tMysqlBulkExec component

Hello,
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(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
disconnected
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2728)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2678)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.tMysqlBulkExec_1Process(Copy_of_jhBulkLoad.java:1240)
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.tRowGenerator_1Process(Copy_of_jhBulkLoad.java:1134)
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.runJobInTOS(Copy_of_jhBulkLoad.java:1490)
at tutorialproject.copy_of_jhbulkload_0_1.Copy_of_jhBulkLoad.main(Copy_of_jhBulkLoad.java:1355)
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 Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads