ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

JCP/JWP not starting with encrypted password

book

Article ID: 237844

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

We have issues with the JCP when starting up with the library ojdbc10 and ojdbc8. 

Once we start up the JCP with these libs, we are getting an invalid connection string exception.

When we put a cleartext the password in the jdbc string of the jcp ini-file it works, but with an encrypted password it fails. 

Strangely, when adding double quotes around the password it works again.

We also tried to encrypt the password again, but this didn't help.

[ODBC]
; ODBCVAR xxxxxxxx
;         |||||||+ type of SQL-Syntax N=SQL-SERVER  O=ORACLE  D=DB2
;         ||||||+- R=compress messages and local memory
;         |||||+-- O = with userid, N = without userid
;         ||||+--- I=OCI/CLI N=ODBC
;         |||+---- not used
;         ||+----- J = compare fieldnames case-insensitiv (in case of ORACLE !!)
;         |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks)
;         +------- S = use Server-Cursor (SQL-SERVER)
;
;         NNJNIORO for Oracle 10.x with OCI (Oracle Call Interface)
;         NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface)
;
; Oracle with OCI
SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=UC4BASE;UID=uc4;PWD=<--encrypted_password>;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15

[JDBC]
SQLDRIVERCONNECT=jdbc:oracle:thin:UC4/<--encrypted_password>@server.domain.com:1521/UC4BASE

OR
SQLDRIVERCONNECT=jdbc:oracle:thin:UC4/"<--encrypted_password>"@server.domain.com:1521/UC4BASE

Cause

The jdbc string does not need a password. The (encrypted) password is taken from the ODBC string.

Environment

Release : 12.3.8

Component : AUTOMATION ENGINE

Resolution

With the following configuration it works:

OBDC string with (encrypted) password:

[ODBC]
SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=UC4BASE;UID=uc4;PWD=<--encrypted_password>;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15

 

JDBC string without password, the password is taken from the ODBC string:

[JDBC]
SQLDRIVERCONNECT=jdbc:oracle:thin:UC4/@server.domain.com:1521/UC4BASE