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.

JDBC Connection Fails To Oracle DB With Advanced Security Enabled

book

Article ID: 200565

calendar_today

Updated On:

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 kind of error:

ORA-12660: Encryption or crypto-checksumming parameters incompatible

Cause

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

Environment

Gateway 9.2 and higher

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)