Product: StreamSets Transformer
Cluster Manager Type: DataBrick
JDBC_00 - Cannot connect to specified database: Error setting up SSL: truststore.jks (No such file or directory)
: conf.connectionConfig.jdbcUrl
Goal:
How to pass the truststore file to connect with SSL enabled Database.
Solution:
These truststore files need to be present in advance to our databrick cluster because spark executor will reference to this path.
- Upload this truststore file to DBFS
- Then specify as additional jdbc parameterSSLKeyStorePath
and absolute dbfs path for this file.
SSLKeyStorePath = /dbfs/<Dir>/trustore.jks