How to give the custom Location of certs in the Denodo JDBC Connection instead of getting it accessed the default one

[jmoghalx]

Since we tried to connect the Denodo with Python code ""com.denodo.vdp.jdbc.Driver","jdbc:denodo://edvp.XXX.com:8000/item?ssl=true", Its taking the default JAVA_HOME\lib\security\certs but I would like to give custom location how?

Example : $JAVA_HOME/bin/java -Djavax.net.ssl.trustStore=/my/custom/truststore -Djavax.net.debug=ssl SSLPoke jira.example.com 443

My Python code is :

try:
# Connect to Denodo
denodo_conn = jaydebeapi.connect(
"com.denodo.vdp.jdbc.Driver","jdbc:denodo://edvp.XXX.com:8000/item?ssl=true",
#sslTrustServerCertificate=true,sslTrustStoreLocation=cacerts,sslTrustStorePassword=Changeit
["sys_XXX", "XXX@2051"], # Replace with your credentials
"denodo-vdp-jdbcdriver.jar" # Path to Denodo JDBC driver
)
denodo_cursor = denodo_conn.cursor()

[yakatz]

I had to fork the library in order to make that work. The place that needs to go is here:

jaydebeapi/jaydebeapi/__init__.py

Line 170 in 53b2d6a

args = []

args.append('-Djavax.net.ssl.trustStore=path/to/truststore.jks')
args.append('-Djavax.net.ssl.trustStorePassword=changeit')