Hi All,
I am facing an issues while making an SSL connection to Hybris Database using Virtual JDBC driver.
I get a Error
-----
connecting to datasource "HybrisvJDBCLocal - service"
SQL Error: java.sql.SQLException: java.security.cert.CertificateException: No name matching qa2.shop.loblaw.ca found
at sun.security.util.HostnameChecker.matchDNS(Unknown Source)
-----
This is a self signed certificate that I created using Open SSL. after that I imported the certificate into the default Java keystore @ C:\Program Files\Java\jre7\lib\security\cacerts file as a trusted certificate.
DBeaver still gives the above error. Any idea please on how to overcome this.
Here are the steps I took to create the SSL certificate using Open SSL:
http://www.dylanbeattie.net/docs/openss ... howto.html
And this is how I imported and trusted the self signed certificate.
keytool -import -alias loblaw1 -keystore D:\HybrisDevSandBox\hybris\bin\platform\tomcat\lib\keystore -file C:\ssl\certs\ca.cer
I can see the certificate in the export file using the below command.:
keytool -list -v -keystore ../lib/security/cacerts > javacertificates.txt
I also read couple of articles but no luck. Here are they for reference,
http://java.globinch.com/enterprise-jav ... ost-found/
Please help.
Thanks
Raghu