Query in Mag database

Products

• CA Mobile API Gateway

Issue/Introduction

I was trying to make a query using context variables in the Perform JDBC Query assertion.
My query:

INSERT INTO movies (name, release_date, rating)
VALUES (${nomeFilmes}, ${dataLancamento}, ${avaliacaoFilme});

But, I'm getting an error that doesn't allow using context variables.

Do you know some assertion in API Gateway 10.1 that allow me to make a query like the one above?

Environment

Release : 4.2

Resolution

Context variable do work in JDBC queries, they are used in other calls like OTK maintenance tasks

What will not work is when the JDBC query is open and clicking the test button, the context variables are not available 

In the example below the test will fail with context variable issue