Forum Discussion

alexis733's avatar
alexis733
Occasional Contributor
8 years ago

Re: Comparing JDBC results

Hello there,   I'm having the same problem. In my case I need to create a JDBC Request to "count" the elements on a certain table of a DB, then I performed some deletions from the DB and later asse...
  • PaulMS's avatar
    PaulMS
    8 years ago

    You can transfer the result of a JDBC request using a property transfer test step or a script assertion (below)

     

    import com.eviware.soapui.support.XmlHolder
holder = new XmlHolder( context.responseAsXml )
context.testCase.setPropertyValue( "Quantity", holder.getNodeValue("//QUANTITY") )

     Note //QUANTITY is in uppercase assuming the default setting to convert names of fields in request results to uppercase

nmrao's avatar
nmrao
Champion Level 3
8 years ago
Provide more details such as your request etc so that some will be able to help.
  • alexis733's avatar
    alexis733
    Occasional Contributor
    8 years ago

    Hello,

     

    This is the SQL statement I want to run before the deletion request.

     

    Select COUNT(*) as quantity
    from dbo.EXP
    where PID = Convert(numeric,:id)     -> id is taken from a Property previously declared.

     

    After the deletion request, I would like to run the same sql statement and in order to compare the quantity and thus assert if the deletion were performed successfully.

     

    Thanks,

     

     

    • PaulMS's avatar
      PaulMS
      Super Contributor
      8 years ago

      You can transfer the result of a JDBC request using a property transfer test step or a script assertion (below)

       

      import com.eviware.soapui.support.XmlHolder
holder = new XmlHolder( context.responseAsXml )
context.testCase.setPropertyValue( "Quantity", holder.getNodeValue("//QUANTITY") )

       Note //QUANTITY is in uppercase assuming the default setting to convert names of fields in request results to uppercase

      • alexis733's avatar
        alexis733
        Occasional Contributor
        8 years ago

        PaulMS, thank you so much.... it worked for me.....greetings