Error with tMysqlBulkExec component

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

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download