Using the correct JDBC version ensures reliable and efficient database connectivity. In order to check the version of an imported JDBC driver, run the below SQL query.

SQL query

select distinct pzjar, pzcodeset, pzcodesetversion from <pegarules_schema>.pr_engineclasses where pzjar like '%<database_type>%';

For example (for Snowflake database type),

select distinct pzjar, pzcodeset, pzcodesetversion from <pegarules_schema>.pr_engineclasses where pzjar like '%snowflake%';

References

Defining the database driver

How to find System properties and third-party versions

Running SQL queries on Pega Cloud

How to set up JDBC Connection to External Database