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
Gateway 9.2 and higher
Additional parameters need to be defined on the gateway data source jdbc url to indicate encryption is required by the Oracle database.
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)