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.
90
questions
1
vote
10
answers
419
views
What to do if a QA tester mistakenly deleted a table from the QA Database?
QA tester mistakenly deleted a table from QA testing env database. Should this be a big deal?
0
votes
1
answer
21
views
jmeter testing mysql and neo4j - neo4j gives me 0 latency and load time comparable to on database execution, but for mysql latency is as big as load
I am testing neo4j and mysql with queries that I want to compare later by latency and sample time considering jmeter as imitation of some web service. I am doing tests for 10000,100000,1000000 rows in ...
-1
votes
1
answer
1k
views
How to connect with Mysql db using Cypress 12?
I want to connect to Mysql DB in the server to delete several records. I have tried using some of the tutorials and answers available. Since all of them are regarding older versions of Cypress, I can'...
1
vote
5
answers
527
views
Is it possible to use Cypress for data validation?
I'm writing some end-to-end automated tests for a CRM-alike web application. One of the development team leaders is asking me to do something that I've never done before.
The problem is that the data ...
0
votes
0
answers
25
views
Can a constraint be added to a database if there's data in it that violates it?
I'm setting up a database migration test project for work and among the issues that we want to cover, we have an old issue where some DB constraint was added, and it was overlooked that sometimes ...
3
votes
1
answer
267
views
Should we write a Test Case for every Foreign Key?
Should I write a test case for every Foreign key in the database?
Our team is conducting a large database migration project using Java APIs, for eg. inputting CustomerSales.
And we have ProductId, ...
2
votes
1
answer
29
views
What is the best way to test values that vary according to database type?
I am working on a program that needs to work on values that are fetched from different database types: currently we support 12 different database types. My code applies some business logic to the ...
0
votes
1
answer
2k
views
JMETER: java.lang.OutOfMemoryError: Java heap space
I have configured Jmeter for database load testing, and have been using the CLI to test load on my redshift database. i have increased the memory heap but the same problem remains
Below is the Error ...
0
votes
1
answer
973
views
JMETER: How do I run parallel JDBC requests in JMeter?
I have defined the JDBC Connection configuration and have added multiple JDBC requests in JMeter.
Currently, when I trigger the requests, the requests are executed one after the other.
I would like to ...
1
vote
1
answer
727
views
JMeter - save response to file listener but also ignore result
In JMeter, I am using a post processor running prev.setIgnore() within the setup thread group to ignore those requests.
Some of these requests are JDBC requests to select data out of the database and ...
0
votes
2
answers
191
views
How would you test this form designed for adding and editing tables in a relational database?
I am having a problem with test cases. I have never tested before the forms that add tables in relational database and I am not sure what is the good approach - should I write down test cases that ...
1
vote
2
answers
1k
views
How to check the data completeness in ETL Testing
I am working on healthcare project. I need to verify the data present in staging tables, DWH tables and target tables. I am checking manually for few records but my management asking to look for a ...
0
votes
2
answers
288
views
Asserting against database during selenium test run
Just wanted to hear some thoughts about asserting against the database during a selenium test suite. For the website I am working on is a SPA with API backend where the majority of the service ...
0
votes
0
answers
69
views
Integration tests and data used in these tests
I read a lot about unit and integration tests and how they work with maven and java and how it works with Continuous Integration.
I am using Flyway for db migrations, the schema part is already done.
...
-3
votes
1
answer
99
views
Tool suggestion for Database Testing
Anyone can suggest/recommand a automation tool which will cover DB testing end2end.
The tool should support sql queries execution,Test Reports generation and support the CI/CD.
1
vote
1
answer
605
views
API tests against production DB with no endpoints to set up test data
I'm creating regression tests for one of our APIs. I'd like to discuss how to go about it in my particular situation.
I have no problem on the dev environment, but when it gets deployed to a staging ...
0
votes
2
answers
138
views
How to automate functional regression tests through database data comparisons?
I have a Java batch job application that reads input data from an Oracle database, does a lots of calculations, handles many edge cases, and outputs results back into different database tables.
The ...
0
votes
0
answers
240
views
How can I integrate database validation (queries, updates) in Ruby, Cucumber, Watir project in RubyMine
I have setup a project in RubyMine using Ruby with Cucumber, RSPEC, and Watir for UI automation of feature files. (I also have page objects implemented). In my step_definitions where the actual UI ...
1
vote
3
answers
531
views
Best practice for testing data integrity between server and UI
I am a QA. This is the software chart:
Search Engine (Apache Solr) <-> Server (expose itself to UI by an API) <-> UI.
The server makes queries on the search engine and send the returned data ...
4
votes
3
answers
477
views
Can existing tests and data effectively compare old and new systems?
This idea was presented to me recently:
You have a complex legacy ETL system in Java in a TEST environment that no one understands completely. You write some tests that run it and compare the output ...
0
votes
0
answers
20
views
The result set has no current row error (Database automation testing using selenium webdriver [duplicate]
I am using the following code in selenium, but I am not able to retrieve data from database. I am getting the error "The result set has no current row"
public class Auto {
public static void ...
-2
votes
2
answers
8k
views
The result set has no current row while using JDBC [closed]
I am using the following code in selenium, but I am not able to retrieve data from database. I am getting the errors "The result set has no current row"
My code is
public class Auto {
public ...
1
vote
2
answers
43
views
Should I obtain data required for particular test case using appropriate endpoint or read it directly from the DB?
I am implementing automated tests of the system that consists of many microservices.
To verify appropriate behaviour of the endpoints using POST and PUT methods, I need to obtain some data (for ...
1
vote
2
answers
338
views
Backend testing
Backend testing is basically a database testing right? Can it be something else? I was asked that question and I have a hard time finding the right answer. Anyone has any ideas? Thanks
2
votes
1
answer
73
views
Test scenario of Database components
For one new project we have a requirement to add multiple "Database Collation" support to the system, means the system will create DB on any specified DB Collations for Unicode, ANSI supported ...
0
votes
2
answers
410
views
How do you store test data into nosql document database for quick read?
I am currently migrating our currently test data that is stored in excel files to a database. Because the type of data in the test results are going to grow we decided to go with nosql instead of sql.
...
0
votes
1
answer
61
views
Possible scenarios for a periodic task that is run daily at 11:40 PM to process a data set available globally
I'm testing an e-commerce website and there is a deviation that is occurring on a daily basis for a periodic task that runs daily at 11:40 PM.
In essence, what this task does that it picks all orders ...
2
votes
1
answer
2k
views
How can I verify text exist within a table with db using Selenium WebDriver?
Using selenium Webdriver+Java- I am looking for a way to identify and or verify a value in a table. There are more columns in the table, but I am only
concerned with the Country column, Also the ...
0
votes
1
answer
280
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 explain my scenario:
When I update a value in application, it also gets updated in LPS system. The LPS is ...
0
votes
1
answer
76
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
3
answers
2k
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 ...
2
votes
1
answer
316
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
2
answers
514
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 ...
6
votes
2
answers
233
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 ...
3
votes
2
answers
423
views
aws data pipeline testing tools
Our team is building an AWS product which uses several sets 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 ...
5
votes
1
answer
312
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 from 1GB to 20GB.
The data is in the same schema with coordinates.
As of now, the approach is to ...
1
vote
1
answer
136
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!
1
vote
2
answers
734
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
1
answer
4k
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
2
answers
142
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). ...
2
votes
1
answer
2k
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?
2
votes
1
answer
2k
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
1
answer
157
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 ...
3
votes
2
answers
5k
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
4
answers
4k
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
2
answers
118
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?
2
votes
1
answer
24k
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 ...
3
votes
1
answer
5k
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
0
answers
74
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
2
answers
133
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
...