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

Anonymous — Sat, 16 Nov 2024 06:10:53 GMT

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.

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

Anonymous — Tue, 02 Apr 2019 19:03:41 GMT

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 🙂

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

Anonymous — Wed, 03 Apr 2019 13:51:20 GMT

Thank you Mr.Thampi. It's working

topic Re: Error: jdbc4.MySQLSyntaxErrorException: Duplicate column name '-' in Talend Studio

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

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

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