API Gateway: Using variables in JDBC queries

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

How can variables be used in JDBC queries?

Environment

Release : 9.3

Component : API GTW ENTERPRISE MANAGER

Resolution

The attached samples show how to use a variable in the perform JDBC assertion. 

If you plan to use the policy as is it will require a JDBC connection be set up to your SSG database. Additionally, you may need to change the name of the database in the query assertion if it is not named as 'ssg'.