JDBC Connection : No suitable driver

Products

• CA API Gateway

Issue/Introduction

When trying to connect to Oracle JDBC connection ( in our case 12.2) 

you may see an error 

Testing failed: invalid connection properties setting.
No suitable driver 

Cause

This indicates that you do not have the appropriate driver loaded into the gateway for the current configuration you are trying to implement.
or our URI is not configured for the driver you have on the gateway 

Resolution

The following KB will be useful for installing a driver on gateway 
https://knowledge.broadcom.com/external/article?articleId=130311

or edit your JDBC URL to look like this 

jdbc:oracle:thin:@hostname:PortNumber/servicename

Additional Information

in our case we had 
jdbc:oracle:@hostname:port Number/servicename

once we added thin it worked