How to configure driver level encryption in PI JDBC Adapter
While attempting to configure SSL encryption with the help of third party database e.g Oracle, MS SQL to the Process Integration (PI)/Process Orchestration (PO) JDBC Adapter.
We can get an error as given below if the configurations are not correct:
java.sql.SQLRecoverableException: IO Error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:209)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:873)
Solution
These error is caused because the encryption of the data sent to the oracle datbase is taken care by the JDBC driver and not by the PI as each and every database provides there own data encryption feature.
The driver parameter must be configured in the Advanced mode of the JDBC channel
And also the driver parameter must be prefixed with driver such as driver:oracle.net.encryption_client
