How to use Additional JDBC Parameters to connect MySQL

[dipanjan93]

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.

[Anonymous]

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-St...

Best regards

Sabrina