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

One Star

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

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
One Star

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

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

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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

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

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

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

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
One Star

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

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

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

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