Forum Discussion

bojasna's avatar
bojasna
Occasional Contributor
4 years ago
Solved

JDBC Request errors when semicolon is included in SQL

When you end your sql statement with a semicolon in JDBC Requests, soapUI fails to run the request and reports the following error: "Error getting response; java.sql.SQLSyntaxErrorException: ORA-0...
  • ChrisAdams's avatar
    4 years ago

    Hi,

     

    In terms of a workaround, you could look at a Groovy script step.  At least then you could script call the db several times and interact with the results in between each.

     

    The downside to the scripting is having to manage creating, opening and closing the connection by using Groovy script, but that isn't too bad to do.