Forum Discussion

easyfish's avatar
easyfish
Contributor
10 years ago
Solved

can not update oracle table in soapui groovy

Hi, I am doing data driven testing. My requirement is to take data from request properties and response properties then insert or update oralce table. Now I can take data from properties and can se...
  • NataliaB's avatar
    NataliaB
    10 years ago

    In what line does this error happen? Did you test your connection string (it can be done using soapui interface)?

     

    Also this part looks confusing to me, you connection is called con not sql

    > sql.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'")

     

    Shouldn't it be con.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'")?

     

    And I belive you need import of goovy.sql.*

NataliaB's avatar
NataliaB
Occasional Contributor
10 years ago

In what line does this error happen? Did you test your connection string (it can be done using soapui interface)?

 

Also this part looks confusing to me, you connection is called con not sql

> sql.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'")

 

Shouldn't it be con.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'")?

 

And I belive you need import of goovy.sql.*

easyfish's avatar
easyfish
Contributor
10 years ago

Thanks so much!

It should be con.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='8888' where TEST_STEP_ID='3.3.3'")