API Gateway: Using variables in JDBC queries

book

Article ID: 142339

calendar_today

Updated On:

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'.

Attachments

1577448122622__jdbc_query_like_variable.xml get_app
1577448113405__jdbc_query_equals_variable.xml get_app