Find API Gateway Policies Using a Specific JDBC Connection
book
Article ID: 127277
calendar_today
Updated On:
Products
STARTER PACK-7CA Rapid App SecurityCA 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"%';