topic Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum in Talend Studio

[resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Tue, 21 Oct 2014 21:35:49 GMT

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

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Tue, 21 Oct 2014 21:52:26 GMT

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???

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Wed, 22 Oct 2014 10:34:26 GMT

Hi,

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

Since the version 5.3.1, some libraries needs to be downloaded by the customer in order for the Studio / commandline to work well.

Have you checked document TalendHelpCenter:Identify required external modules and TalendHelpCenter:Install external modules?

Best regards
Sabrina

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Wed, 22 Oct 2014 11:42:22 GMT

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!!!

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Wed, 22 Oct 2014 12:07:00 GMT

I have installed the version 5.6RC and it works!!!
What happens with V5.5??
My installation is corrupted??

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Wed, 22 Oct 2014 16:35:44 GMT

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

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Wed, 22 Oct 2014 20:10:02 GMT

Sure!
If I open the projet and execute the same jobs with talend V5.6, they work!!

Re: [resolved] mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate colum

Anonymous — Thu, 23 Oct 2014 07:43:45 GMT

fixed with V5.6RC not solved with V5.5