could not load database driver via Postgres database

Products

• CA Process Automation Base

Issue/Introduction

Attempting to connect to a PostgresSQL DB and getting "could not load database driver".  How to connect to a postgres database?

Environment

Release: ITPASA99000-4.3-Process Automation-Add On License for-CA Server Automation
Component:

Cause

The Postgres JDBC driver was not deployed correctly to the orchestrator resources

Resolution

First deploy the postgres JDBC Driver into the Orchestrator Resources on the Configuration Tab:

Which will place the file in the \CA\PAM\server\c2o\.c2orepository\.c2oserverresources\lib\ directory:

Specific directions on adding Orchestrator Resources can be found in the Process Automation Orchestrator Resources documentation.

 

Then within your Process Definition:

1.- Select Postgres in Connection Wizard.

2.- Fill up the variables for Driver with the following:

Process.driver = “org.postgresql.Driver”

3.- Modified the connection string generated by the wizard with this:

“jdbc:postgresql://”+ Process.host + “:” + Process.port+ “/” + Process.db”

NOTE: When ‘Postgres’ is selected in the Connection Wizard, by default the URL is generated with the following: “jdbc:”+ null+”://” .  This needs to be changed to “jdbc:postgresql://”. 

 

 

 

Additional Information

postgresql Documentation