How to use Additional JDBC Parameters to connect MySQL

dipanjan93 — Sat, 16 Nov 2024 05:33:41 GMT

Hello ,

I am trying to connect MySQL DB with Additional JDBC Parameter as per the below expression -

"noDatetimeStringSync=true & useSSL=true & requireSSL=true & ssl_key=D:/xxx/key.pem & ssl_cert=D:/xxx/cert.pem & ssl_ca=D:/xxx/ca.pem & zeroDateTimeBehavior=CONVERT_TO_NULL"

Could you please let me know how to use the correct version of it? As using the above expression is throwing an exception as below -

Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:379)
at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(Unknown Source)
... 27 more
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
at sun.security.provider.certpath.PKIXCertPathValidator.validate(Unknown Source)
at sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(Unknown Source)
at java.security.cert.CertPathValidator.validate(Unknown Source)
at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:372)

Thanks.

Re: How to use Additional JDBC Parameters to connect MySQL

Anonymous — Wed, 19 Jun 2019 08:41:10 GMT

Hello,

Could you please let us know if this community article helps?

https://community.talend.com/t5/Architecture-Best-Practices-and/Learned-By-Doing-How-to-connect-a-Studio-job-to-a-MySQL-Server/ta-p/35675

Best regards

Sabrina

topic How to use Additional JDBC Parameters to connect MySQL in Talend Studio

How to use Additional JDBC Parameters to connect MySQL

Re: How to use Additional JDBC Parameters to connect MySQL