Forum Discussion

easyfish's avatar
easyfish
Contributor
9 years ago

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
    9 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
9 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
    9 years ago

    Thanks so much!

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