Forum Discussion

bojasna's avatar
Occasional Contributor
4 years ago

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



    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.