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.

TextSoap 8 on Bundlehunt

If you are the type of person that needs to handle a lot of Find/Replace functions, or parse through logs, or strip extraneous characters from text taken from the web, TextSoap 8 should make a great tool in your arsenal. I just picked it up the other day from Bundlehunt for the super low price of $5 and I've already done a fair bit of text parsing. TextSoap comes with literally hundreds of pre-made actions to strip out extraneous text or even add text blocks back in. For example, you can add the HEAD, H1, and other block markers. Remove all the tags from some HTML source code. Convert to Lowercase/Uppercase. Wrap text at a specific column number. Remove Whitespace and Carriage Returns. Remove extra space. Change formatting styles. Parse text with RegEx. And if that wasn't enough, you can always build your own "Cleaner." I've already run through several conversions to strip away HTML, remove characters and get plain […]