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)
