Query in Mag database
search cancel

Query in Mag database


Article ID: 268021


Updated On:


CA Mobile API Gateway


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?


Release : 4.2


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