When customer is trying to connect to Mysql 8 DB on Talend 8 R2024-05 it is giving the below error:
===============
javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:842)
at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:821)
===============
Customer is using MySQL Driver: mysql-connector-java-8.0.12.jar
Resolution
- You can try to add "useSSL=false" in the Additional parameter of the MySQL component's Advanced settings in Studio and republish the job to TAC and run it again. Please review the below links https://stackoverflow.com/questions/52724001/sslexception-for-connecting-mysql-db. You just need to set "?useSSL=false" in the Additional parameter section of the job in your Studio to something like below: String url="jdbc:mysql://localhost:3306/samp1?useSSL=false";
- You can download mysql-connector-java-8.0.16.jar or the latest driver and point the job to it in your Studio. Below are articles on how to import external jars on Qlik Talend Documentation Site: importing-external-library and installing-external-modules-manually-using-modules-view
Cause
It seems that it is a bug with the MySQL driver. It looks like sql drivers 8.0.16 and below are affected.
https://bugs.mysql.com/bug.php?id=93590
https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-16.html
Related Content
https://bugs.mysql.com/bug.php?id=93590
https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-16.html
Environment
Talend Studio
