Want to join 2 excel sheets with tMap

Anonymous — Sat, 16 Nov 2024 02:40:47 GMT

I am trying to join 2 excels using tMap using a common key i.e. ID and store it in MySQL database.

Exception in component tDBConnection_1 (Combining2Excels)
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test_ankita.combining2excels_0_1.Combining2Excels.tDBConnection_1Process(Combining2Excels.java:3702)
at test_ankita.combining2excels_0_1.Combining2Excels.tPrejob_1Process(Combining2Excels.java:3609)
at test_ankita.combining2excels_0_1.Combining2Excels.runJobInTOS(Combining2Excels.java:3990)
at test_ankita.combining2excels_0_1.Combining2Excels.main(Combining2Excels.java:3842)
Exception in component tDBOutput_1 (Combining2Excels)
java.lang.NullPointerException
at test_ankita.combining2excels_0_1.Combining2Excels.tFileInputExcel_1Process(Combining2Excels.java:1402)
at test_ankita.combining2excels_0_1.Combining2Excels.runJobInTOS(Combining2Excels.java:4005)
at test_ankita.combining2excels_0_1.Combining2Excels.main(Combining2Excels.java:3842)

Re: Want to join 2 excel sheets with tMap

manodwhb — Thu, 16 Apr 2020 02:44:33 GMT

It is issue while connecting to the db,have you able to create metadata connection for that db?

topic Want to join 2 excel sheets with tMap in Talend Studio

Want to join 2 excel sheets with tMap

Re: Want to join 2 excel sheets with tMap