Exception in component tDBOutputBulkExec_1_tMBE (Mysql)

Anonymous — Fri, 12 Jul 2019 13:23:09 GMT

Hello,

i charged the data with tmysqloutputBulkExec, in the end of execution the job i have this error:

Exception in component tDBOutputBulkExec_1_tMBE (DSA__Acquisition_poule_competition_penalite_forfait)
java.sql.SQLSyntaxErrorException: The used command is not allowed with this MySQL version
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:781)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
	at local_project.dsa__acquisition_poule_competition_penalite_forfait_0_1.DSA__Acquisition_poule_competition_penalite_forfait.tDBInput_1Process(DSA__Acquisition_poule_competition_penalite_forfait.java:2443)
	at local_project.dsa__acquisition_poule_competition_penalite_forfait_0_1.DSA__Acquisition_poule_competition_penalite_forfait.runJobInTOS(DSA__Acquisition_poule_competition_penalite_forfait.java:5318)
	at local_project.dsa__acquisition_poule_competition_penalite_forfait_0_1.DSA__Acquisition_poule_competition_penalite_forfait.main(DSA__Acquisition_poule_competition_penalite_forfait.java:4919)

any Help please?

Re: Exception in component tDBOutputBulkExec_1_tMBE (Mysql)

Anonymous — Wed, 17 Jul 2019 08:32:04 GMT

Hello,

Are you using load data local infile command? What's MySql DB version are you using? It seems MySql 5.1 or higher one will be able to support that.

Best regards

Sabrina

topic Re: Exception in component tDBOutputBulkExec_1_tMBE (Mysql) in Talend Studio

Exception in component tDBOutputBulkExec_1_tMBE (Mysql)

Re: Exception in component tDBOutputBulkExec_1_tMBE (Mysql)