Questions tagged [sql]
Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server, nor does it refer to specific dialects of SQL on its own.
48
questions
0
votes
0
answers
13
views
How do you validate millions of data in 2 different databases as part of ETL Testing
How to validate millions of data in 2 different databases as part of ETL (Extract, Transform, Load) Testing.
And in the same databases, also tell me the testing process to validate the Target DWH (...
0
votes
1
answer
24
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'...
0
votes
1
answer
789
views
JDBC connection to databricks server is failing in JMeter
I have working JDBC connection to data bricks server in Java code.
I'm trying to make similar connection in my JMeter project (tried with apache-jmeter-5.3 and apache-jmeter-5.4.3) using same ...
1
vote
2
answers
231
views
how to send the DB fetched values to frontend using selenium?
I wrote a program where values are coming from sql database.Now i want to send those values to frontend using selenium.
say it is an pincode i fetched from Database but now if locate the element where ...
0
votes
1
answer
139
views
Running sql query via automation tests in Visual studio vs SQL server management studio returns different results
I am running some database automation tests in C#.The results of the same sql query are different in visual studio(executed via automation tests) and SQ Server Management studio(Manually).The ...
1
vote
2
answers
13k
views
Cannot load JDBC driver class 'oracle.jdbc.OracleDriver' in JMeter
I have the problem with running a script in JMeter.
I get the following error message
Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'
Does anyone know how to solve it?
0
votes
2
answers
68
views
Testing GET API interactions with Oracle
We have some GET APIs written in Python which fetches some data from Oracle i.e. there are some SQLs written in Python APIs through which it fetches the data from Oracle. This is not consumed by an ...
0
votes
0
answers
244
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 ...
2
votes
1
answer
84
views
How to test Oracle DB?
I have to test using SQL in Oracle if the data stored in the DB is completely correct or not. For example, make sure we are up to date, no future dates, no invalid characters on varchar columns, etc.
...
0
votes
1
answer
429
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.
...
3
votes
2
answers
1k
views
Should I store my test results in a database or google docs?
I'm currently trying to decide what is the better place to store my test results; database (sql/nosql) or in a spreadsheet placed in google docs.
I have the impression that storing it into a database ...
0
votes
2
answers
749
views
Selenium, data driven testing using NUnit and SQL queries.
I am developing a Selenium Test Automation Framework for the purpose of testing multiple websites.
I have currently set up the Framework in Visual Studio using C# and implementing the Page Object ...
0
votes
2
answers
4k
views
Is there any way to validate sql data with cucumber feature file data?
I am using cucumber , Junit , Selenium Web driver and have JDBC connection
I have a feature with below scenario
Scenario Outline: Fill out the ATS Registration Form
When Click on SignUp
And ...
1
vote
1
answer
2k
views
What is Sql data conditioning?
This question was asked during QA interview. What is SQL data conditioning?
Is it creating test data using SQL scripts to test different scenarios?