Bonjour,
Je dois essayer d'extraire des données grâce à Talend Open Studio depuis une base de donnée SQL Server vers une base MySQL. Mais j'ai les erreurs suivante (voir fichier joint) :
******
Exception in component tMysqlOutput_1
com.mysql.jdbc.exceptions.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 '0) not null ,primary key(`RegionID`))' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1027)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2430)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2359)
at com.mysql.jdbc.Statement.execute(Statement.java:719)
at talenddemosjava.test2_0_1.test2.tMSSqlInput_1Process(test2.java:532)
at talenddemosjava.test2_0_1.test2.runJobInTOS(test2.java:961)
at talenddemosjava.test2_0_1.test2.main(test2.java:870)
****
Que dois je faire ?
Partager