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 ...
- 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: ...
- 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 ...
- 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 ...
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 ...
- 191
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
- 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.
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 141
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 ...
- 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 ...
- 161
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 = '${...
- 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 ...
- 461
Only top scored, non community-wiki answers of a minimum length are eligible