-
How to Assert Service Response Values against a Database
How to Assert Service Response Values against a Database Description: The following workflow will demonstrate a method to validate the data from a Service Response against the data stored in a Database. I will be using the database and Service Response from our Parabank 2.0 Application as an example. If you wish to learn…
-
Need to access application database for test data used in Selenic tests
I have a simple application that is used as a front end for another department's database. We only have read access and cannot create our own test data. What I would like to do is to make a few database queries to retrieve some key values to use in the subsequent tests. Are there examples of this available? Thanks!
-
Extension Tool SQL Data Capturing into Datasource
Hi All I am fetching the data from DB Sql query using Extension Tool the Data is fetching successfully & showing in Console but the issue is i am not getting how to capture those Data and store in Datasource for future usage , Can someone help me on this.
-
Unable to record database queries using parasoft
I tried pointing application servers to parasoft JDBC driver but it is not recording /capturing database query and my application doesn't start.
-
Compare datasource(expected data) with actual data in the database
Hi Parasofters, I have a problem. I am putting data in a database(SQL developer) via a process which loads some XMLs in the database. I have the expected data in a datasource in parasoft soatest. I want to compare the actual data in de database with the expected data in the datasource within parasoft soatest. How can I do…
-
Warning Message : No test resource appears to be selected.
When i try to run test case for DB Connection (Oracle). I get warning message "No test resource appears to be selected. Do you want to use resource from the last test run?" when select "Yes" in warning window, it runs last test run. BUT does not execute DB Connection test case.
-
Virtualize : Use Database as datasource and parameterize SQL query
We are using excel as a datasource and parameterized the responder response. Since excel has limitations on rows , I wanted to use Database as a datasource. But, if i use database , the query needs to be parameterized since account number i use is unique every time. Based on the account number i need to get the rows from…
-
Unable to connect to Parasoft DB
Hi all, I am unable to connect to Parasoft DB. It gives me the following error :smile: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CUSTOMER My settings are as below -- Driver : org.hsqldb.jdbcDriver URL : jdbc:hsqldb:hsql://localhost/parabank Username : SA Please help! Thanks, Arindam.
-
Configuring MySQL 5.7 on Ubuntu 18.04 for DTP
With Ubuntu 18.04, they changed how they operate and how packages are installed with apt-get. For one, the MySQL server installation no longer asks for a root password at startup and this will need to be configured in another part. The way MySQL authenticates was changed as well and this too will need to be updated. To…
-
Trespass Database datasource cache
When i use a database as datasource the virtualize creates a cache from the table when deploy (or when request first time idk), but i need to access updated data sometimes. There is any workaround for this?
-
How to upgrade from Concerto to DTP
In order to perform the migration from Concerto to DTP, there are several things you need to consider both before and during the migration process. Backing up your System First, before migrating from Concerto 4.x to DTP 5.x, you should back up your Concerto data files as well as your Database to prevent any loss of data.…
-
How to increase Continuous Testing Platform Marketplace Virtual Asset upload size limit
You can increase the upload size limit by doing the following: 1.) Shut down MySQL and Tomcat 2.) You need to edit the my.ini file in the MySQL installation, specifically you need to add: max_allowed_packet=100M 3.) Turn on MySQL and Tomcat Keep in mind that private marketplace items you upload get stored in the database.…
-
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…
-
Iterate through the Database Data Source
Hi, I am current attempting to use a Database Data source to verify result returning from the web service. I've created a simple test suite that included a Database Data Source (DDS) and a simple test. This test would include a XML Transformer and XML Assertor. The DDS contains a simple SQL that return 1 column with 3 rows…
-
DB Tool SQL error: SQL command not properly ended
I'm trying to execute a DB Tool test. I get the following error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Scenario: * Set-Up Tests * Tear-Down Tests * Test 1: authorize * Test 2: DB Tool * Test 3: redeem My SQL: SELECT UPDATE_APP_NAME FROM CREDITACCOUNT.CREDIT_PROVIDER_REBATE WHERE…
-
Parasoft SOA test is getting hanged when i try to invoke a 2MB size excel file into data source?
Hello, I am using Parasoft SOA test 9.9. * Create a .tst. * trying to add a excel sheet to data source (excel file size is almost 2MB). everytime I import the excel , I am getting an error that Parasoft is not responding or the tool get freezed. I will have to go to Task manager to end the process. Is there any limit in…
-
Assert JSON Response with multiple Rows from the DB
I'm really struggling with getting this to work, I thought this would be an easy use case for the software. However comparing the multiple rows from the JSON response to an equivalent query in the database isn't working. Here's what I've tried: 1. Create a writable data source that will be populated from a JSON databank.…
-
DB tool with extension tool
I am very new to SoaTest and was having difficulty utilizing the extension tool with the DB tool. I was wanting to access the results of a db tool query within the extension tool but was having difficulty doing so. The input object just shows "text" where if i attach the extension tool to a soap response, I will recieve…
-
is it possible compare between Response (Soap /Json) and Data source using java
Hi , My scenarios is to compare between response (SOAP/Rest) and database using any of the scripting language Like Java / Groovy /Jython (Mostly Using Java ) , how can i compare those , i m entirely new to Programming Language (Know Basic Concept very well )
-
Exporting DB Tool Table Traffic Results
Hi, Is there a way to export the traffic results from the Table view when running the DB Tool? This is exactly what I want to export into .csv but when I use the Write File, I get the Literal View and not the table view. I also looked at http://forums.parasoft.com/index.php?showt...hl=writetoexcel but I only got 1 row…
-
Assert Value against database
Hi, I would like to know using SOATEST 5.5 how can I assert that the value returend in a SOAP/XML response from my webservice is the same as in the DB. Thanks in advance
-
Can I test database connectivity with .TEST?
.TEST provides a powerful execution engine. You can use .TEST in the presence of code connecting to databases in different ways. If you prefer, you can connect directly to the database. If you do not want to connect to the database, then you can use the user level stubs feature that .TEST provides to run the tests in…