Find API Gateway Policies Using a Specific JDBC Connection

Article Id: 127277

Status: Published

Updated On: 30-09-2019 08:51

Products:

STARTER PACK-7 , CA Rapid App Security , CA API Gateway , CA API Gateway , 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"%';