Error: jdbc4.MySQLSyntaxErrorException: Duplicate column name '-'

[Anonymous]

Hi everybody,

This is my job design. I get this message when I running this job.

Exception in component tMysqlOutput_1 (AracEslestirme)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'Bez'
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)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:788)
at local_project.araceslestirme_0_1.AracEslestirme.tMysqlInput_1Process(AracEslestirme.java:1876)
at local_project.araceslestirme_0_1.AracEslestirme$2.run(AracEslestirme.java:8592)

And I couldn't what does mean?

Any helps?

Thanks a lot.

[Anonymous · Accepted solution]

Hi,

The error says you have two entries in the schema with column name "Bez" as the error is Duplicate column name 'Bez'.

Could you please double check your schema in both tMap and tMySQLOutput Components?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thank you Mr.Thampi. It's working