Forum Discussion

thatsthat's avatar
thatsthat
Contributor
2 years ago

Executing JDBC on its own runs the query but as part of a test case the same JDBC step fails to run.

Quite puzzled by this. When I kick off this Test case .. the JDBC step ('JDBC Status Check') fails and I see the below in the error logs. But if I now go directly to the step and run it on it...
Data-Driven Testing
Function Tests
  • mrdwprice's avatar
    mrdwprice
    2 years ago

    When it executes (and fails), grab the JDBC Status Check SQL from the Raw tab.
    Try to run that separately, check for syntax errors.

    Perhaps you are using property expansion in the sql that is not being set as expected which is breaking the SQL statement - Incorrect syntax near the keyword 'and'

mrdwprice's avatar
mrdwprice
Contributor

When it executes (and fails), grab the JDBC Status Check SQL from the Raw tab.
Try to run that separately, check for syntax errors.

Perhaps you are using property expansion in the sql that is not being set as expected which is breaking the SQL statement - Incorrect syntax near the keyword 'and'

thatsthat's avatar
thatsthat
Contributor
2 years ago

Ahh spot on mate .. found the error of my ways by looking at the RAW value.

Cheers