Identify Policies using a JDBC Connection

Products

• CA API Gateway

Issue/Introduction

The OAuth database is external to the gateway. There's a plan to move from Oracle to Exadata. We want to list all policies that use the OAuth JDBC connection.

Environment

API Gateway 10.1

Resolution

There are only a few assertions where you can specify a JDBC connection. 

select name from policy where xml like '%L7p:ConnectionName%OAuth%' and name not like '%OTK%';

If no results come back, then you don't have any user-defined policies that reference an OAuth JDBC connection (outside of the actual OTK policies).