Layer7 API Management

  • Private Community
Back to discussions
Expand all | Collapse all

JDBC Query behaves strangely with keyword 'LIMIT'

  • 1.  JDBC Query behaves strangely with keyword 'LIMIT'

    Posted Jul 27, 2015 10:19 AM

    I'm trying to query a MySql database, using an assertion configured like this:

    problem.jpg

    When i use the context variable "offset" in the query (initialized with "Set Context Variable" for example to 1 either as a String or as an Integer), this assertion fails but when i replace the variable with a number in the query itself it does work. Am i doing something wrong?

    Thank you in advance.

     

     

    EDIT:

    Solved removing the check from"Convert variables to Strings" and using an integer variable, because the query necessary needs an integer after "LIMIT".

     

    Messaggio modificato da Simone Turello