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)
Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

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

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch