Find API Gateway Policies Using a Specific JDBC Connection

Products

• CA API Gateway

Issue/Introduction

There are three JDBC connections defined with same the configuration. The preference is for all policies to use once JDBC connection. Which policies are referencing which JDBC connection?

Environment

All supported versions of the API Gateway

Resolution

To find out what policies are referencing a particular JDBC connection, run the following query against the ssg database: 

select name from policy where xml like '%ConnectionName stringValue="jdbc_connection_name"%';