API Gateway: MySQL JDBC Connection encryption using TLS example

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Enterprise Service Manager (Layer 7)
• CA Microgateway

Issue/Introduction

How can we encrypt an existing JDBC connection to a MySQL database?

Are there additional properties that are put after the JDBC URL as options?

Need to know the additional properties details to configure JDBC connections over TLS ?

Environment

Release : 9.4

Component : API GATEWAY

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