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.

     

bojasna's avatar
bojasna
Occasional Contributor

Hey richie 

Thanks for the answer. I'll check out the paid version to see if it has what I need. It's a bit of a shame it's not fixed since I saw other people asking the same thing, but what can you do 🙂

ChrisAdams's avatar
ChrisAdams
Champion Level 3
4 years ago

Hi,

 

I don't believe the paid version gives you this either.  From my own experience, I know that you cannot have semi-colon's in the command.

 

It actually makes sense to restrict each JDBC step to a single SQL statement, otherwise it would be hard to tease out the response for assertions.

 

In terms of connecting to a db from Groovy, here is a good start... Link.  Here is another example from the coding challenge last year... TechCorner-Challenge-13-Call-Database-Connection-Using-Groovy  

 

Once you have a connection in a Groovy script step, then you can run whatever query you like....

// Note conn is the db connection

def theSmiths = conn.rows("SELECT surname FROM user WHERE surname = 'Smith'")

log.info(theSmiths);

 

I suppose the choice you have is based on the number of queries to execute.  Lots of queries, then Groovy.  Few queries, stick to JDBC steps.

 

  • richie's avatar
    richie
    Community Hero
    4 years ago
    Hey ChrisAdams,

    What version you using? I use semi colons in all my JDBC steps all the time!?!?!?!

    Ta

    Rich
    • ChrisAdams's avatar
      ChrisAdams
      Champion Level 3
      4 years ago

      Hi richie , I'm using ReadyAPI 2.7.0.  I've had problems in the past with a semi-colon in a JDBC step, but now you've got me doubting myself!