I am using Talend 6.3.1 with Java 8 installed. In Talend job when I use tAmazonMySqlConnection component then I am able to establish the connection with "RDS" if executed on LocalHost. But when I change target execution to one of the remote server job fails and error is on above component as "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communication link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."
Can anyone please let me know what am I missing here?
Thanks & Regards
From the error message, we see that it is failed to connect to AmazonMySql server from the production server.
Please check whether you are able to ping to the AmazonMySql server from the production server.