Connecting Katalon to a Postgres Database

One of our goals for this year was to connect Katalon into our Postgres instance. It turned out to be quite simple, but we ran into a couple of errors before we got all the magic to happen.

When using the standard connection string, we get an hba_conf error along with ssl=true errors. This can be fixed in the connection string by appending the two following parameters:

sslfactory=org.postgresql.ssl.NonValidatingFactory
ssl=true

The connection string to be placed in Katalon looks like:

jdbc:postgresql://hostname:5432/dbname?sslfactory=org.postgresql.ssl.NonValidatingFactory&ssl=true

With this connection string in place, we were able to connect to the database without issue and execute queries.

Other articles of interest:

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments