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.

SOA Test DBTool is returning Null value for correct query

Options
arijitpal001
arijitpal001 Posts: 1
edited December 2017 in SOAtest

Hi,
DB tool with Oracle is returning null value. The same query in Toad returns valid record from DB.

Sometime if we execute DB tool multiple times it might reflect any record (which is intermittent).

Also if we parameterize the query it shows record for only for the last parameter(in-case if it returns any record)

Even I wrote a extension tool using jython code but same observation

SOA Test Version:9.10
Oracle JDBC Version: ojdbc6-11.2.0.3.jar
Jython 2.5.3

Any help would be appreciated!!

Answers

  • Nitzi
    Nitzi Posts: 19
    Options

    Hi Arijit, Have you checked the DB tool is connecting to the oracle database at the first place? bcz it seems like connection issue with oracle database. I would refer changing the oracle jdbc jar file to lower or higher version. See if it helps.