Forum Discussion

prouser's avatar
prouser
Contributor
12 years ago

Running a prepared sql stmt in JDBC test step

Hi, I am new to Soap UI Pro . Am trying to transfer a prepared sql statement from groovy test step to the JDBC test step and run the JDBC test step. Succesfully transferred the prepared stmt using the property expansion, '${Groovy#Result}'. But, Iam encountering the error, "DB2 SQL Error : SQL Code=-104, SQL State=42601" when I run the JDBC test step

The query runs fine when I run in it the Squirrel SQL Client. It returns one column , several rows

Appreciate any help on this

2 Replies

  • SiKing's avatar
    SiKing
    Community Expert
    12 years ago
    I don't think your '${Groovy#Result}' is what you think it is.
    Try to write the result into a property, and expand that property in your JDBC step.