Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (4)
7 Replies
Anonymous
Not applicable
Author

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???
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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!!!
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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

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