Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

DB tool returning as blank where the SQL query in oracle returning null

Options
satyabrata
satyabrata Posts: 5 ✭
in SOAtest

Hi ,

We have connected to DB tool in Parasoft test to connect to oracle.

When we run the query in DB visualizer connecting to oracle for one of the column its returned as null however when we run in DB tool its returning as blank.

Is there any setting in DB tool tool return the column value same as returning in Oracle.

Thanks,
Satyabrata Das

Comments

  • jakubiak
    jakubiak Posts: 798 admin
    Options

    It looks like null and empty string mean the same thing in Oracle - I suspect that this is the behavior of the Oracle JDBC driver. I would like to see if there is something you can do in the SQL query to change how it gets returned?

    Also does this help?
    https://stackoverflow.com/questions/31403994/replacing-null-with-blank-cell-in-sql-query-result

  • benken_parasoft
    benken_parasoft Posts: 1,231 ✭✭✭
    edited August 2021
    Options

    Depending on the version of SOAtest, null values are represented in the DB Tool's SQL result XML output as either 0 or empty string. In the current release, it is empty string. So, at present, you can't disambiguate between empty string and null. This is a known limitation.

  • benken_parasoft
    benken_parasoft Posts: 1,231 ✭✭✭
    Options

    In the current release, it is empty string. So, at present, you can't disambiguate between empty string and null.

    This limitation was addressed in the 2021.2 release. The XML representation of the result set now uses an empty element but with an xsi:nil="true" attribute. The table viewer renders this as "[null]" similar to how null values are shown in data repository tables.

Categories