Find API Gateway Policies Using a Specific JDBC Connection

book

Article ID: 127277

calendar_today

Updated On:

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