Register Login

Configure driver level encryption in PI JDBC Adapter

Updated May 18, 2018

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


×