If the Job fails, you may see error information like the following on the Run console:
Exception in component tDBInput_1 (EncryptPasswordWithR0T13Demo) java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
This error indicates that you have failed the authentication when trying to connect to
the database. Check that:
- You have the right user name/password for the database connection before encrypting the password using ROT13.
- You have transformed the right encryption string from your real password using a custom routine.
- You have provided the encryption string as the default value of context variable.
- You have correctly configured the database component to call the custom routine function.