Can an ldap type jdbc connection be used in ucsrv.ini?
search cancel

Can an ldap type jdbc connection be used in ucsrv.ini?

book

Article ID: 217756

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

The Oracle database is accessed via the Service Name in ucsrv.ini under the ODBC section. 
The DBA has built out a standby database reachable via the same service name. 
When we need to switch to the standby database, the ODBC connection continues to work without modification.
However, as the JDBC connection string uses 'hostname' we have to manually modify this connection string.
The DBA suggested using the LDAP type JDBC string to avoid the manual changes each time, but this does not seem to work.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Oracle Database

Cause

The error message in the JWP logs appear as:

U00003545 UCUDB: Opening database ...
U00045025 OSGI ['com.automic.kernel']: '[com.automic.kernel.impl.ServerProcess(31)] The activate method has thrown an exception'
               Unhandled Exception in thread main
U00045014 Exception 'java.lang.NoClassDefFoundError: "javax/naming/directory/DirContext"' at 'oracle.net.resolver.AddrResolution.<init>():240'.
U00045015 The previous error was caused by 'java.lang.ClassNotFoundException: "javax.naming.directory.DirContext cannot be found by com.automic.database_1.0.0"' at 'org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal():508'.

Resolution

Although Oracle supports authentication to the database using an LDAP server, this is not currently supported for use with Automic Automation.