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.

 

bojasna's avatar
bojasna
Occasional Contributor
4 years ago

Hi ChrisAdams ,

 

Thanks for the answer. Do you by any chance have some link to an explanation or maybe examples of how these scripts would look like, since I'm not sure what to search for?

 

Thanks,

Bojana