Error with tMysqlBulkExec component

Anonymous — Fri, 13 Dec 2013 20:30:58 GMT

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)

Re: Error with tMysqlBulkExec component

Anonymous — Sat, 14 Dec 2013 14:56:46 GMT

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

topic Error with tMysqlBulkExec component in Talend Studio

Error with tMysqlBulkExec component

Re: Error with tMysqlBulkExec component