JWP does not start with postgresql JDBC exception.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The JWP does not start after switching to PostgreSQL as a database.

U00045025 OSGI ['com.automic.kernel']: '[com.automic.kernel.impl.ServerProcess(14)] The activate method has thrown an exception'
               Unhandled Exception in thread ConfigurationListener Event Queue
U00045014 Exception 'java.lang.NoClassDefFoundError: "javax/security/auth/callback/CallbackHandler"' at 'org.postgresql.core.SocketFactoryFactory.getSslSocketFactory():61'.
U00045015 The previous error was caused by 'java.lang.ClassNotFoundException: "javax.security.auth.callback.CallbackHandler cannot be found by com.automic.database_1.0.0"' at 'org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal():508'.
U00003620 Routine 'com.automic.kernel.impl.DefaultExceptionHandler' forces trace because of error.

Environment

Release : 12.3.2

Component : AUTOMATION ENGINE

Cause

Configuration.

Resolution

The sqlDriverConnect string needs to be changed from:

sqlDriverConnect=jdbc:postgresql://PostgreSQL_Server:5432/db_name

To:

sqlDriverConnect=jdbc:postgresql://PostgreSQL_Server:5432/db_name?sslmode=verify-full&sslfactory=org.postgresql.ssl.NonValidatingFactory&sslfactoryarg=classpath:cert/certificate_name.p12