API Gateway: MySQL JDBC Connection encryption using TLS example

Products

• CA API Gateway

Issue/Introduction

Is it possible to encrypt an existing JDBC connection (over TLS) to a MySQL database? Are there additional properties required after the JDBC URL as options?

Environment

API Gateway 9.4

Resolution

To add SSL to your MySQL JDBC Connection add the following to your JDBC URL: ?&useSSL=true&verifyServerCertificate=false




The JDBC URL should go from: 
jdbc:mysql://url.to.database_hostname/test_db_name
to
jdbc:mysql://url.to.database_hostname/test_db_name?&useSSL=true&verifyServerCertificate=false

Additional Information

Support for TLS 1.2 was added in Gateway 9.4 (DE378269)