Forum Discussion

dejvid-smth's avatar
dejvid-smth
New Contributor
5 years ago

Groovy's Sql broken after update to Ready API 3.1

I have a Test Case where I need to first insert a row into an Oracle DB and then I need to do something with it. To solve that I have used a Groovy script Test Step to insert a row using groovy.sql.S...
Scripting
  • sonya_m's avatar
    sonya_m
    5 years ago

    Thank you richie!

     

    Hi dejvid-smth, have you managed to solve this? Do let us know:smileyhappy:

    We can try to continue the investigaion here if it is still an issue - I see that richie requested additional clarifications from you.

     

    Also, this might be a good idea to contact Support and describe the issue to them in detail.

dejvid-smth's avatar
dejvid-smth
New Contributor

Hi richie , 

 

I have tried INSERT via JDBC but to my knowlege you can't get the value of generated column back from the insert via JDBC step or by using DataSource step. We also don't support creating this data through HTTP API unfortunately. 

richie's avatar
richie
Community Hero
5 years ago

Hi dejvid-smth 

 

sorry - for my understanding - can you clarify what you mean by "you can't get the value of generated column back from the insert via JDBC step"

 

I can see in your groovy - your 'return col' statement.  Are you inserting a row into a table and then perhaps a stored proc fires updating the value and your script previously retrieved this updated value (via 'return col')? or something like this? 

 

If my notion is somewhere in the vicinity of correct and considering your comment I quoted above - do you mean that if you apply the insert you would need an additional query to retrieve the updated column value?

 

you can separate multiple queries within a single JDBC step - oracle sql requires semi colons terminating everything unlike say sqlserver (but its not enforced in soapui) - but could you not just follow up your INSERT query with a relevant SELECT within the same JDBC test step?

 

or have I totally misunderstood and got it totally backwards?

 

Nice one,

 

rich

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    5 years ago

    Thank you richie!

     

    Hi dejvid-smth, have you managed to solve this? Do let us know:smileyhappy:

    We can try to continue the investigaion here if it is still an issue - I see that richie requested additional clarifications from you.

     

    Also, this might be a good idea to contact Support and describe the issue to them in detail.