Forum Discussion

MERKSEN's avatar
MERKSEN
New Contributor
13 years ago

[Res] JDBC-datasource and XPATH, problems comparing []...

The jdbc-datasource I use sometimes contains null values, like in this simplified example: Id Name Email 123 Carl carl@test.com 124 Steve (null) When called, the SOAP-serv...
SmartBear_Suppo's avatar
SmartBear_Suppo
SmartBear Alumni (Retired)
Hi,

You can set you JDBC TestStep assertion as follows:
exists(//Results[1]/ResultSet[1]/Row[1]/SECOND_SURNAME[1])
and the Expected result will be "true".
Since the node exists, the assertion will pass even if the value is null.

Regards,

Giscard
meital's avatar
meital
New Contributor
9 years ago

I have the result: 

<Results>
<ResultSet fetchSize="128">
<Row rowNumber="1">
<MODEL_ID>Deposit</MODEL_ID>
<VALUE1>1</VALUE1>
<VALUE2/>
<VALUE_SET/>
<SCORE>1.00</SCORE>
</Row>

not sure how to say i am expecting to null in VALUE2?

If i am declaring the expected result null i am getting failue

expected null actual null.