Service Virtualization

Hi All,

I am storing SQL database execution step response as xml. For the values which are null in DB. It sometimes stores as <string /> and sometimes as <null />. Due to which by Graphical side by side comparison assertion fails. Any idea how to resolve this? 

What database are you querying?  is there a sample Result set you can provide?

I am querying Neo4j DB.

I Just ran another test. for one of the value below its showing <string></string>  whereas earlier it came as  <null />

<com.itko.lisa.jdbc.JDBCResultSetCache>
<rows>
<list>
<string>TEST</string>
<string>TESTUSER</string>
<string>VERIFIED</string>
<string>MASON</string>
<string>OH</string>
<string>222 UBRAN RD</string>
<string></string>
<string>45041</string>
<string>NO_MAIL</string>
<string>5C5A153D-2F45-49D4-8D0E-E41663C9A2F9</string>
<null/>
<null/>
</list>
</rows>
<columns>
<string>app_name</string>
<string>app_user</string>
<string>AddressStatus</string>
<string>CITY</string>
<string>STATE</string>
<string>LineOne</string>
<string>LineTwo</string>
<string>Zip</string>
<string>Mail_Status</string>
<string>Address_Uuid</string>
<string>PhoneNumber</string>
<string>PhoneType</string>
</columns>
<maxRows>2147483647</maxRows>
<columnCount>12</columnCount>
</com.itko.lisa.jdbc.JDBCResultSetCache>

Tushar, I will test this out at my end, but is it Ok if I open a support ticket for this?  

Tushar,  its looks like Neo4j DB is not supported.  Our database steps are SQL steps using a pure Java JDBC driver. Unfortunately, NeoDB uses the Cypher Query Language and not Sql query .    

You can try to use Java script step and write your own query  for comparison  instead of using  Graphical XML assertion or filter