Find API Gateway Policies Using a Specific JDBC Connection

Products

• STARTER PACK-7
• CA Rapid App Security
• 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

Release: L7SGA299000-9.2-API Gateway SOA Gateway-HARDWARE APPLIANCE DUAL CPU
Component:

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"%';