Service Virtualization

Expand all | Collapse all

SQL Database execution step

Jump to Best Answer
  • 1.  SQL Database execution step

    Posted 05-16-2018 10:42 AM

    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? 



  • 2.  Re: SQL Database execution step

    Posted 05-16-2018 01:25 PM

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



  • 3.  Re: SQL Database execution step

    Posted 05-16-2018 01:51 PM
      |   view attached

    I am querying Neo4j DB.

    Attachment(s)

    zip
    sampleResultset.xml.zip   470B 1 version


  • 4.  Re: SQL Database execution step

    Posted 05-16-2018 01:59 PM

    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>



  • 5.  Re: SQL Database execution step

    Posted 05-16-2018 02:16 PM

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



  • 6.  Re: SQL Database execution step
    Best Answer

    Posted 05-23-2018 05:49 PM

    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