3 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 ...
Dmitri T's user avatar
  • 13.5k
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: ...
Cherree's user avatar
  • 1,189
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 ...
dzieciou's user avatar
  • 10.5k
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 ...
Peter M. - stands for Monica's user avatar
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 ...
ghellquist's user avatar
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
PDHide's user avatar
  • 11.1k
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.
VSD's user avatar
  • 97
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 ...
Alexey R.'s user avatar
  • 11.6k
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 ...
Alexey R.'s user avatar
  • 11.6k
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 ...
Moro's user avatar
  • 1,052
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 ...
learning2learn's user avatar
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 ...
Peter M. - stands for Monica's user avatar
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 ...
Dmitri T's user avatar
  • 13.5k
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 ...
Dmitri T's user avatar
  • 13.5k
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 ...
Jeremy Kowalski's user avatar
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 = '${...
Dmitri T's user avatar
  • 13.5k
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 ...
Edward_Haigh's user avatar

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