-
Error In Database Tool SQL
I have a rather messy SQL Server query that runs fine in MicrsoftSQL Server Management Studio but in SOATest's DB Tool it is throwing this error at runtime: SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with indexed views…
-
How to execute DB tool in a loop
Hi, I need to execute DB tool query in a loop based on the count is fetched at run time which depends on the number of array elements in my json payload. Kindly help me with a solution, Thanks in advance!!
-
Get values from the DB tool response and compare with external excel.
In SOAtest, I want to get the values from the response of a DB tool and compare those against the values in an external Excel sheet. Then, I want to derive success or Failure of the test. I tried XML Data Bank or JSON Data bank but both of them doesn't show the DB response. They just show the Select query and the elements…
-
How to convert a test into spring boot project?
I need to integrate parasoft test suites into spring boot project. How do i do that?
-
Handling IN OUT parameters in DB Tool Stored Procedure calls
I have a Oracle DB Stored Procedure with the following signature SCHEMA.PACKAGE.PROCEDURE(IN VARCHAR, IN VARCHAR, IN VARCHAR, IN OUT VARCHAR, OUT VARCHAR, OUT VARCHAR, OUT VARCHAR, OUT VARCHAR, OUT INTEGER, OUT VARCHAR). As you can see, there is one parameter that is both an input AND output parameter. I have tried…
-
Stored Procedure not executing in soatest - giving error message
Hello,I’m having a problem with the DB Tool, where a stored procedure is not working as expected. The same exact stored procedure is working on Toad for Oracle, and I’m able to get the query result I expect. Using the DB Tool in SOAtest, I get the following error:“Error Message:ORA-00922: missing or invalid option42000…
-
DB Tool Oracle DB Connection Issue
Hi Team, I have added "DB Tool" Output on Incoming Request and have given the "Driver", URL, and UserName and Password. When deployed the Virtual Service to Parasoft server and tested, getting the following error. Please help me with this issue. I have added class path in Parasoft tool in Parasoft-->Preferences-->JDBC…
-
DB Tool Issue
I am using DB tool to retrieve data from SQL Server. In DB the value is 0.0000003 but while returning in soatest it shows as below 3.00000E-7 Not sure about the conversion.Could you pls check and confirm.
-
SOAtest : DB Tool passing extracted values using XML Data bank to other queries in specific format
I am using DB tool with Results as XML -> XML Data Bank, it returns many rows as a result and I want all values of say nth field as input to succeeding queries in test scenario workflow. Is there any simplistic way to do this? For example first query select * returns few rows with fields say f1,f2....fn, I want all values…
-
Virtualize : Map DB Tool Result Sets To XML Response
How to map multiple rows returned from resultSet to the XML response ? We have a SOAP Message responder having below xml response. I need to parameterize the account numbers in the response <findTransactions> <transactions><accountNumber></accountNumber></transactions> </findTransactions> In the above xml response the…
-
DB Assertion Regardless of order
I have a test where I query a DB and returned with a list of values. I want to be able to make an assertion to check if certain values exist regardless of order or position in the result. Is this possible? So far, my team mates who are working on this as well have been unsuccessful
-
DB Tool - Password as a environment variable
How can we define the DB Tool password as an environment variable.As for different environments its different so its hard to change in all DB tools manually?
-
Compare values in writeable with db output
I have saved a writeable with 5 values. I have a DB tool which is used to fetch the result of SQL query . It gives me more than 50 records. Now I need to validate if that 5 records in writable is available in the 50 records of db result. Please help how to perform this validation.
-
Perform Arithmetic and Logical assertions on two writeables/tables
I have to implement the below scenario: I have to compare the DB values from 2 different tables and perform logical and arithmetic operations on them. Steps implemented: * Create a new test suite * Create a DB tool and query to fetch data (multiple columns) from a table 1. I need to save the run time values. I created a…
-
SOA Test DBTool is returning Null value for correct query
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…
-
Inserting values in DB from the transformed response
Hi, I'm using style sheet to transform my response into something I care about from the fields standpoint. What I want to do is extract the values from the transformed response and insert that in the DB My transformed xml is looking like this 2017-10-17T13:45:00.61-04:00 9476102124 HIGH_SPEED_DATA 1 choice WiFi Business…
-
DB Call returns "None" in write file
Team, I have test suite which has test "DB Tool" . It reads values from abc.txt file. Here is query - SELECT CUST_ID || CUST_CD || CUSTNAME FROM xx.table_table WHERE CUST_ID = '${PQR}' AND CUST_CD = '580'; While abc.txt file contains PQR values. while generating file I am getting "None" also in file Which I do not want.…