Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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