Forum Discussion

bojasna's avatar
bojasna
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...
Scripting
  • ChrisAdams's avatar
    ChrisAdams
    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.

     

ChrisAdams's avatar
ChrisAdams
Champion Level 3

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.

 

richie's avatar
richie
Community Hero
4 years ago
Ooh! ChrisAdams, im a dunce sometimes, thats a good point!

Rich