Hot answers tagged

7 votes

How much SQL knowledge do I need to learn Selenium Testing

For writing Selenium tests itself, none. Selenium does not use SQL. Now if the application under test uses SQL, maybe you need a bit of knowledge to setup test data for your tests. For basic SQL ...
4 votes

Comparing Sqlite databases

I have always loved using Scooter Software - Beyond Compare (limited to 2 links) to visually compare between folder, files etc. Group of them or single. This should help with an easy to use Visual ...
  • 141
4 votes

How to test CRUD operations in Database Testing?

CRUD stands for Create, Read, Update and Delete. (Retrieve may occasionally be substituted for Read.) Different users may have different CRUD cycles based upon the requirements of the system. A ...
  • 4,550
4 votes

What is Sql data conditioning?

When someone asks me a question and I don't know the answer, I tell them I don't know the answer, and then I ask them to tell me what they think the answer is. Maybe you should do that next time. If ...
  • 23k
3 votes
Accepted

Using a different database engine for testing

I'm a little out of date using sqllite but data types and stored procedures come to mind as feature gaps between sqllite and something like PostgreSQL. Beyond features, configuration settings (ex: ...
  • 1,189
2 votes

Need guidance on how to prepare for an SQA interview

[W]hat sort of direction should I head in for learning and practicing my SQL? W3Schools has good info on SQL. There are many flavors of SQL (MySQL and T-SQL are the big ones) but the basics are the ...
  • 4,030
2 votes
Accepted

getting an error in selenium using java with mySQL: java.sql.SQLException: No suitable driver found

Usually this exception occurs when the JDBC URL is wrong and not accepted by loaded drivers. You should have the jar files in the classpath. Also Try using JDBC driver specific URI prefix, which is ...
  • 256
2 votes

Is it necessary to verify databases for functional automation testing?

I believe it is a very good idea read back from the database. The reason is that things sometimes (or often) are not quite as simple as they may look. In the example above: what happens if the phone ...
2 votes

How much SQL knowledge is needed to learn Selenium?

To automate tests in Selenium you don't need to know SQL at all. However, knowledge of SQL helps in general in testing and test automation, for instance: finding useful test data automating test ...
  • 10.4k
2 votes

How can I return values for 2 columns in my database?

This is common problem, usually solved by object-relation mapper (ORM) helper library. There are many for Java (too many), so it is not easy to choose a good one. :-) Do your research before you ...
2 votes

Should I store my test results in a database or google docs?

Unless you have a clear demand on automated processing I would tend to storing results in Google Sheets. Here are few points for the choice: You can easily manage the data from wherever you are since ...
  • 11.4k
2 votes

Is there any way to validate sql data with cucumber feature file data?

It is obviously possible. I won't give you the code but I'll give you the direction: First you should rework public void jdbcdemo(). Add static modifier to the method. Also add the parameters ...
  • 11.4k
2 votes

Cannot load JDBC driver class 'oracle.jdbc.OracleDriver' in JMeter

As per Let's Start chapter of JMeter Getting Started Guide If you want to perform JDBC testing, then you will, of course, need the appropriate JDBC driver from your vendor. JMeter does not come ...
  • 12.7k
2 votes

Running sql query via automation tests in Visual studio vs SQL server management studio returns different results

I was able to resolve this by embedding a CAST(expression as varchar(max)) in my sql query and then run the query via automation test in visual studio.
  • 97
2 votes
Accepted

how to send the DB fetched values to frontend using selenium?

driver.findElement(By.name("pincode")).sendKeys(rs.getString(1)); Is this what you looking for
  • 10.9k
1 vote

Testing GET API interactions with Oracle

What you actually have to do is prepare your test data. Depending on the project, access rights and so on, you got a couple of options: Keep some test data in the database, have a script to recreate ...
  • 1,037
1 vote

Should I store my test results in a database or google docs?

I think based on your second paragraph mentioning future benefits of SQL-style, plus the need to bring in a lot of results, go that way now. The points made by Alexey R are good though. Designing a ...
1 vote

Using a different database engine for testing

Using a different database engine makes sense only if you use just a bland simple SQL, avoiding any performance-enhancing tricks your chosen database provides. IMHO that would be sub-optimal: you ...
1 vote
Accepted

JMeter - Pass http response values to jdbc request without using xpath extractor?

If for some reason you don't like XPath Extractor you can always switch to Regular Expression Extractor, the relevant configuration would be something like: Reference Name: the same value you use in ...
  • 12.7k
1 vote

JMeter - Pass http response values to jdbc request without using xpath extractor?

What's wrong with XPath Extraction? Is there a specific reason you cannot use XPath? You can use RegEx extractor, but keep in mind you are going to have to build a pretty well structured query to get ...
1 vote

How to use xpath referance name in JDBC Request SQL Query?

Depending on your id column type you can do it in 2 ways: If id is VARCHAR type you will need to surround ${Productid} reference with quotation marks like: `SELECT * FROM prodcut WHERE id = '${...
  • 12.7k
1 vote

How much SQL knowledge is needed to learn Selenium?

None. SeleniumHQ define Selenium simply as a tool which automates browsers. You can work with Selenium without any knowledge of SQL. However, you could combine Selenium and SQL to run more ...
1 vote

How to automatically test TSQL?

The most straightforward option seems to be using Microsoft Visual Studio. See How to: Create a Test Project for Database Unit Testing for details. If you looking for a free open source standalone ...
  • 12.7k
1 vote

How much SQL knowledge do I need to learn Selenium Testing

Unless you are doing any database or backend testing, you dont need any SQL knowledge for selenium. Selenium is a UI automation tool. In case if your test data is separated by any Database, you may ...
1 vote

How much SQL knowledge do I need to learn Selenium Testing

The key part of your question is "to learn selenium" To learn selenium you don't need SQL knowledge inh order to be able to write good selenium test cases. However a broader answer includes the ...
1 vote

How much SQL knowledge do I need to learn Selenium Testing

For Data Driven testing / Validation I used SQL Queries. It depends on your test scenario, Few Examples You perform a UI operation. Results are listed. You can perform the same query from DB and ...
  • 2,726
1 vote

Excel worksheets: summarize a bunch of sheets using indirect

solution create a "summary" worksheet that connects all related worksheets this concept works for any data with a shared PK (primary key) all we're really doing is using standard VLookup ...
1 vote
Accepted

SQL - data testing - Oracle 11g lookup tables

issue solution - exact same results, but much faster execution
1 vote

Need guidance on how to prepare for an SQA interview

Aside from the required technical information described from the previous answers, be prepared to answer abstract questions that test the way you approach a problem. For example at a recent interview, ...
  • 329
1 vote

Need guidance on how to prepare for an SQA interview

My main questions to you, kind sirs and mams, are, in an SQA interview, what sort of direction should I head in for learning and practicing my SQL? You could download MySQL to your local machine ...
  • 3,725

Only top scored, non community-wiki answers of a minimum length are eligible