My environment: "Talend Open Studio for Data Integration" Version: 5.5.1 Build id: r118616-20140617-1110 My SQL server : 5.6.12 I have this type of error with several jobs: Démarrage du job ReplEcomcli a 22:27 21/10/2014. connecting to socket on port 3780 connected Exception in component tMysqlOutput_1 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'null' 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:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:908) disconnected at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:788) at optimis.replecomcli_0_1.ReplEcomcli.tFileInputDelimited_1Process(ReplEcomcli.java:2255) at optimis.replecomcli_0_1.ReplEcomcli.runJobInTOS(ReplEcomcli.java:6385) at optimis.replecomcli_0_1.ReplEcomcli.main(ReplEcomcli.java:6244) Job ReplEcomcli terminé à 22:27 21/10/2014. Any ideas? Thanks Didier
I have the following error with a SQLServer database Démarrage du job ReplEcomcli a 22:50 21/10/2014. connecting to socket on port 3630 connected Exception in component tMysqlOutput_1 java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at optimis.replecomcli_0_1.ReplEcomcli.tFileInputDelimited_1Process(ReplEcomcli.java:2223) at optimis.replecomcli_0_1.ReplEcomcli.runJobInTOS(ReplEcomcli.java:6385) at optimis.replecomcli_0_1.ReplEcomcli.main(ReplEcomcli.java:6244) disconnected Job ReplEcomcli terminé à 22:50 21/10/2014. So a talend issue???
Strange, because in the same projet I have several jobs based on the same template and the same taget MySQL database. It works for 2 jobs and not for the 6 other jobs!!!
Hi Didier, Your case is certainly strange. Are you sure the two jobs that work use the same MySQL table? You mention SQLServer, are you using MySQL component with a MSSQLServer database? Maybe if you could upload some screenshots of your failing jobs, this could help figure out where the Duplicate column name 'null' error comes from. Elisa