Forum Discussion

JackStoneS's avatar
JackStoneS
Occasional Contributor
9 years ago

NullPointerException on XPathContains (JDBC-teststep): why?

I have a JDBC-teststep, requesting some info from a database. I get some rows back, and want to assert their validity with an XPathContains. For the first row, this works: the data matches and the ...
  • nmrao's avatar
    nmrao
    9 years ago
    Glad to know that it worked.

    As mentionedarlier, list order of Rows may get changed.

    Below should have worked too(it is different from initial reply)
    //Results/ResultSet/Row[@rowNumber='2']

    I think you should rely on VISSOORT is DAB.

    Hope this helps. You can close it by accepting the solution if you wish.
nmrao's avatar
nmrao
Champion Level 3

Can you try the below

 

//Results/ResultSet[Row[@rowNumber='2']]/Row

JackStoneS's avatar
JackStoneS
Occasional Contributor
9 years ago

That expression seems to match all of the rows:

 

XPathContains assertion failed for path [//Results/ResultSet[Row[@rowNumber='2']]/Row] : Exception:org.custommonkey.xmlunit.Diff [different] Expected attribute value '2' but was '6' - comparing at /Row[1]/@rowNumber to at /Row[1]/@rowNumber

 

Select from current: "More than one match in current response"

 

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago

    Sorry about it, try this one:

     

    //Results/ResultSet/Row[@rowNumber='2']

     

    Even the above may fail at times if the row order changes, in that case you may use below one as Value of VISSOORT is DAB

     

     

    //Results/ResultSet/Row[VISSOORT='DAB']

    • JackStoneS's avatar
      JackStoneS
      Occasional Contributor
      9 years ago

      The XPath with VISSOORT='DAB' works, but for the @rowNumber='2', but I get the same NullPointerException.

       

      Could you explain why this works? Both of the XPaths should give the same row back. Why does one fail?

      • nmrao's avatar
        nmrao
        Champion Level 3
        9 years ago
        Glad to know that it worked.

        As mentionedarlier, list order of Rows may get changed.

        Below should have worked too(it is different from initial reply)
        //Results/ResultSet/Row[@rowNumber='2']

        I think you should rely on VISSOORT is DAB.

        Hope this helps. You can close it by accepting the solution if you wish.