JDBC Connection Fails To Oracle DB With Advanced Security Enabled

Products

• CA API Gateway

Issue/Introduction

Using a configured JDBC data source on the gateway fails to connect to an Oracle database once Advanced Security is enabled on the Oracle side using Transparent Data Encryption with the following error:

ORA-12660: Encryption or crypto-checksumming parameters incompatible

Environment

Gateway 9.2 and higher

Cause

Additional parameters need to be defined on the gateway data source jdbc url to indicate encryption is required by the Oracle database.

Resolution

Adding the following kind of parameters to the end of the defined jdbc url allows the gateway to successfully connect to the Oracle DB with Advanced Security enabled:

encryptionlevel=required;encryptiontypes=(AES128,AES192,AES256)