Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

an organized collection of data, typically organized to model relevant aspects of reality, in a way that supports processes requiring this information.

0
votes
1answer
74 views

How to check webservice response in database using Selenium or UFT

I have an application. Different web services gets called when any action is performed. Let me explaian my scenario: When i update a value in applciation it's also get updated in LPS system. The LPS ...
0
votes
1answer
28 views

What is the best approach/tools to test data copy from Oracle to SQL Server?

I have test data copy from Oracle database to SQL Server. Data will be copied every hour. Data in Oracle is constantly changed and in SQL Server it will be in read-only mode.
1
vote
3answers
71 views

How to have Selenium tests which also verify the database information?

I’m now relatively well versed in using Selenium when it comes to UI testing, but there is one area which I’m not too confident on which I haven’t seen covered much in the courses I have taken, and ...
3
votes
1answer
57 views

How to create unit tests for Web app with a database

I'm currently adding unit testing to my project and came across this question, How can I test my database insertion. For example, let's say I have a user table, I want to test if I can create a user, ...
0
votes
0answers
51 views

Robot Framework Database Cleanup

I am currently implementing test automation using Robot framework to component test our dockerized system. Since I am not that familiar with best practices of QA, I would like to know your opinion and ...
0
votes
2answers
60 views

Comparing data from from a webservice response with data that is in the database

I am automating testing web services in robot framework RIDE and I am getting the response I am expecting and saving the response to variables. So I would like advice on how to go about comparing the ...
0
votes
0answers
36 views

How to automate data entry for a dashboard meant for project status updation and analyse for insights?

So I've been assigned the work to create a dashboard for info on the ongoing projects in the firm. I've built a basic dashboard on Tableau and am planning to ask the employees to enter data into a ...
6
votes
2answers
75 views

Using a different database engine for testing

This was inspired by the Speeding up Django unit tests with SQLite, keepdb and /dev/shm article that demonstrates how switching from PostgreSQL to an in memory SQLite helps to speed up testing during ...
1
vote
0answers
173 views

aws data pipeline testing tools

Our team is building an aws product which uses several set of tools like lambda, SNS topics,EC2, data pipelines etc. I would like to know what type of testing tools/strategies that can be used to ...
3
votes
1answer
109 views

Approaches for testing huge data files in text format

My current assignment requires me to test data in a large number of text files ~ 200, usually ranging between 1GB to 20GB. The data is in same schema with coordinates. As of now the approach is to ...
1
vote
1answer
29 views

What all do we need to test in the application is undergoing a Mongo upgrade?

The application I'm working on is going to have a Mongo upgrade from Version 3.3 to 3.4 What all do we need to test and should care about apart from the general system sanity and regression? Thanks!
0
votes
2answers
132 views

Automating database testing

In database testing, I learnt sql queries and then compare the expected and actual result. Like this if I search for the GUI elements parameters, the DB entries will be displayed in the DB I can ...
2
votes
1answer
2k views

How to load test MongoDB using JMeter?

I want to load test MongoDb using JMeter, but apparently MongoDB Source Config and MongoDB Script have been deprecated. Please let me know how to load test MongoDB with detailed step by step ...
1
vote
2answers
60 views

Jmeter load test: verifying the speed of the service response

I'm doing load test with Jmeter on web application. Recently I noticed that some of the service responses from the application server started taking longer time to arrive to the client (browser). ...
0
votes
1answer
397 views

How can I Use JDBC Request/Debug Sampler results match with HTTP Response in JMeter?

How do I use JDBC Request/Debug Sampler results match with HTTP Response in JMeter using response assertions? Can you provide me with an example?
0
votes
1answer
820 views

Functional Difference between NUnit and MSTest in VS

We are using VS Community 2015 and have the choice of developing under the MSTest or the NUnit framework. We are building a testing framework using Legitest (unit, integration, system, etc) for ...
4
votes
1answer
108 views

What is best practise for Data Contract management?

We are implementing a testing framework, covering areas like mentioned in this SE article. But in addition, as part of unit testing (probably), we want to perform data contract testing. The database ...
2
votes
2answers
1k views

How to access database from SoapUI for test-data generation?

The web-services testing would cover more cases if it is data-driven. So it is better to generate random data (but from the same boundary) for each request. E.g. in test case 1 we check users id ...
1
vote
4answers
1k views

How can I compare content in two similar databases?

I need to compare two databases which have many tables in it. Both databases are the same but we are running different scripts to load and validate the data. How will i do this? Can I use Selenium?
1
vote
2answers
96 views

Compare MySQL and Cassandra?

I am trying to test a migration of data from a mySQL database to a Cassandra database. What would be a good approach to do that and is there any tool to make my life easier?
0
votes
0answers
22 views

Ways to test user-generated reports/mailing lists?

Let's say I have a database-based tool that allows users to create mailing lists or reports on the fly from database tables. I want there to be a way for them to test or verify that the output they ...
0
votes
1answer
6k views

Cannot load JDBC driver class 'com.mysql.jdbc.Driver' in Jmeter [closed]

When you running below Jmeter test plan then "Cannot load JDBC driver class 'com.mysql.jdbc.Driver' response message given. Can any one have any solution for this? Response code: null 0 Response ...
4
votes
1answer
3k views

Efficient way to test data quality of database through java?

I currently have to test the data that is being processed from a file into the database. Currently I'm using Java to extract the data from the database and compare the data mapped to the table ...
2
votes
0answers
60 views

Database testing error [closed]

I am connected mysql databse in eclipse.i am trying to test enter ui value is match in databse or not so i have write code for that but i am not getting satisfied output My code is listed below: ...
1
vote
2answers
72 views

How to perform databse testing in selenium webdriver [duplicate]

I am new in selenium.i am trying for the database testing in selenium webdriver using eclipse. i have install mysql 6.3 server and configure ojdbc14.jar and mysql-connector-java-5.1.25.jar in eclipse ...
1
vote
1answer
48 views

What are some basic (essential) mongoDB queries that a QA ought to know to search and update documents for testing purposes? [closed]

Please list a few examples using which I can search (find) and update documents in mongoDB to test things.
3
votes
1answer
845 views

Data Validation Testing using selenium

I am doing functional automation testing for a web application for analytics using selenium+TestNG. This application fetches huge amount of data from database and displays it on the platform after ...
8
votes
4answers
268 views

QA testing - Database privileges

I have question about DB privileges for QA tester. Our company has set strict rules for DB privileges and QA tester has mostly just privileges to view/read for all tables. There is occasionally case ...
3
votes
3answers
172 views

How do I automate regression testing against external web services, databases, etc …?

The main goal is to be able to send some messages through a current live system and trace outputs all along the way, then replay those same messages in a newer updated version of the system and ...
0
votes
0answers
2k views

How to read Data from XML file and compare the Data with Database Tables as an output using Selenium?

I have to test more than 250 feeds which contains of listing data. Hence, the goal is Download feeds file from existing legacy system which is in XML format and then compare the values with New(re-...
-1
votes
1answer
142 views

What strategy should follow for Testing after complete data migration process?

We are migrating our legacy product to new product with database changes. I have following questions : What process should we follow ? What are major risk factors? What if we found blocker or ...
10
votes
5answers
972 views

Can a proportionately scaled down testing environment find performance load issues?

At my company, we are working on ways to improve our testing of database changes, in our testing environment first. Since there are no resources to have a production like volume of data in servers ...
2
votes
1answer
60 views

Designing database reliant tests for parallel execution

Looking for some best practice here: I'm looking to future proof the selenium tests that I'm building. They'll involve shared elements (products/locations/users), and it seems like a bad pattern to ...
7
votes
6answers
413 views

How to do more effective database testing?

I am testing a financial web-based application having the back-end built on SQL Server. As far as DB testing is concerned, I test simply whether any value/input entered in the UI application is saved ...
1
vote
1answer
56 views

Compare SQL database after delete/update statements

We have had some issues where an update or delete operation on the database would update/delete more records then expected. This has passed multiple layers of testing and reviews. Now I am looking for ...
3
votes
1answer
4k views

How to test CRUD operations in Database Testing?

C: Create R: Retrieve U: Update D: Delete How can a tester verify that CRUD operations are working fine in Web App/Database testing? Please explain with real examples!
3
votes
1answer
403 views

How do I put a MySQL fixture in a PHPUnit driving a Selenium2?

I have a Symfony2 web project using PHPUnit for the unit tests. Recently I added functional tests with the package phpunit/phpunit-selenium. I have added tests to do a login, then to create an item ...
1
vote
4answers
69 views

Performance of a database for a particular task

Scenario: We have a PL/SQL task and are interested in its performance with certain configurations of the database. This includes global features of the database along with the addition of hints for ...
6
votes
6answers
5k views

Does selenium webdriver capable for database testing?

After reading so many answers and forums it makes me confuse. some people says: Selenium webdriver is browser automation tool and it has nothing to do with the database. And some other showing JARs ...
4
votes
1answer
495 views

Handle conflicts in parallel execution of jUnit testruns using the same database

I am actually working on how to manage the execution of many jUnit classes calling the same database, the tests interact using Web-services. If it is possible, it would be a great help if you would ...
10
votes
3answers
6k views

Controlling database state in Selenium UI Testing

We have a big test suite with around 300+ tests. Now a days we are manually restoring database and creating few Data Objects and hard coding some data to feed into the tests. However, there are a lot ...
3
votes
5answers
17k views

How to test database as a manual tester? [closed]

I have just joined as a Junior QA and am learning how to test web apps. However, I have stumbled onto the point where I am not aware of the database testing. What are some tools that are under use ...
8
votes
2answers
382 views

Test design for MongoDB

I am reviewing the information in the MongoDB documentation regarding test design which is a good 'how' of implementing a test, but I am curious if anyone has any feedback or know of additional ...
0
votes
2answers
106 views

Using TDD when developing a database schema?

I am fairly new to TDD and database development. If I wanted to use test driven development when I am trying to create a database schema how would I do that? What are the common tools and processes ...
-1
votes
3answers
3k views

how to do automated testing on both front end and database [closed]

the testing includes front end GUI testing and database verification and some files verification under windows/linux. I know that selelnium can be used for front end GUI testing. what about the other ...
2
votes
1answer
4k views

Robot Framework data-driven automation testing: Can data derived from a database be used as a data source for a test template?

I am familiar with using template keywords in data-driven Robot Framework testing and know that external sources of data such as text files and csv files can be used to provide test data. However, the ...
3
votes
1answer
5k views

Selenium WebDriver (Java) with database [closed]

I want to validate application output result with Database using selenium webdriver (Java). Please let me know how this can be achieved. Or could you please let me know how to use selenium webdriver ...
0
votes
3answers
475 views

Can db2 scripts be automated?

I have a scenario where it is necessary to execute some scripts daily.Is it possible to automate the execution via some tools.?
3
votes
2answers
122 views

Proper pattern for setting up tests of basic database operations

Trying to write tests for basic database operation, I'd like to understand what is the standard or proper pattern for setting up the data, so that only the functionality that should be tested is ...
5
votes
1answer
84 views

Standard set of unit tests for data layer code

While designing test cases for an application's database code (the data layer), I would like to determine a good subset of tests to run in order to guarantee its proper function. In essence, the goal ...