These many days i thought i have quite a good amount of knowledge in Jmeter to perform any performance testing, but after watching your videos in depth i understood that Jmeter provides such small but advanced features which helps you to conduct performance testing in a better way. - Big Thank you for providing these knowledge:)
Hi Asmaa In JMeter, you can assert on data in a database by using JDBC Assertion. Here's a step-by-step guide on how to do it: 1. Set up the JDBC Connection: - Add a JDBC Connection Configuration element to your Test Plan. - Configure the necessary database connection details such as URL, driver class, username, and password. 2. Execute the SQL Query: - Add a JDBC Request element to your Thread Group. - Specify the SQL query that retrieves the data you want to assert. - Choose the appropriate query type (e.g., Select Statement). - Set the Variable Name to store the results of the query. 3. Add the JDBC Assertion: - Right-click on the JDBC Request element and select Add -> Assertions -> Response Assertion. - In the Assertion Control panel, select "JDBC Response Assertion" from the dropdown menu. - Click on the "Add" button in the Patterns to Test section. - Select "JDBC Variable" as the Field to Test and enter the variable name that stores the query results. - Choose the appropriate Pattern Matching Rules and Patterns based on your data validation requirements. 4. Configure the Assertion: - Specify the expected values or patterns in the Patterns to Test section. - Choose the appropriate Assertion Test type (e.g., Contains, Equals, Matches, etc.). - Set the Scope of assertion (e.g., Main sample only, Main sample and sub-samples, etc.). 5. Run the Test: - Save your Test Plan and run the test in JMeter. - JMeter will execute the SQL query and perform the assertion based on the configured rules. - The test results will indicate whether the assertion passed or failed. By using the JDBC Assertion, you can validate the data in your database during the test execution and determine if it meets your expected criteria. If the assertion fails, it indicates a mismatch or inconsistency in the data, allowing you to identify potential issues or errors. Note: Ensure that you have the appropriate JDBC driver for your database installed and added to JMeter's classpath before using the JDBC elements.
Hi sir iam dedicatedly learning from your sessions, I have a few questions here What is response code 200 means? Are these 15videos full corse Can you please make a video for in real time what are the main features we use? Please show us more APIs Thanks a lot for all ur hard work and knowledge sharing
Hi, response code 200 is a success code, that means your request is received by the server and is correct and the server has also responded, now there are several codes in the series 2xx, you can see the list here - www.restapitutorial.com/httpstatuscodes.html
I have one query I am working as a test manager and a automation tester + manual tester Basically single tester in whole team How we should show the test report to the stakeholders for both the manual and automation testcases and what are some of the KPI I can show to the team
Hi Raghav! Thanks for these AWESOME JMETER tutorials!! I plan to watch all of them this weekend. Can I just ask for 1 thing? Can you show how to write real-time results to a database? Mean how to right things such as http response time and assertions for each request into a database right after each one is returned? I know how to write MySQL db connections and queries but not sure where to write them in Jmeter and how to code to get the response information so I can write them into a variable to put into the MySQL code (I did something like this for my Selenium Java framework to show tests that passed, failed, are running, and still need to run). I plan to integrate the DB to a webpage I am making so that every few seconds it will query the test run as it is running, so I can see matrix number, such as if average response time is increasing or decreasing, how many hits have been made. So pretty much I will be making a monitoring tool to see live results/numbers as the test runs. Thanks!
Hi Raghav you said Assertion are applicable on response they why are we applying it on the request. I know this is a silly questions please clear it out for me
Hi Rohit, If I said that, it's incorrect and sorry for that, Assertions can be made on requests to, Assertions = Checks, and we can check both request and response
These many days i thought i have quite a good amount of knowledge in Jmeter to perform any performance testing, but after watching your videos in depth i understood that Jmeter provides such small but advanced features which helps you to conduct performance testing in a better way.
- Big Thank you for providing these knowledge:)
Most welcome Aditya, and thanks for your message
I love your lessons. They're easy to understand, even to someone who hasn't studied IT like me. They do help me a lot in my work. Thank you so much!
You're very welcome!
Thanks for these tutorials, noticed today marks 1year that you uploaded 😊🤗
Wow, So happy to know that Daniel, thanks
Great explain
Thanks Shahzaib
Thank you for the video man
Most welcome
Thank you so much for your efforts.
Can i assert on Data in Database ???
Appreciate your help
Hi Asmaa
In JMeter, you can assert on data in a database by using JDBC Assertion. Here's a step-by-step guide on how to do it:
1. Set up the JDBC Connection:
- Add a JDBC Connection Configuration element to your Test Plan.
- Configure the necessary database connection details such as URL, driver class, username, and password.
2. Execute the SQL Query:
- Add a JDBC Request element to your Thread Group.
- Specify the SQL query that retrieves the data you want to assert.
- Choose the appropriate query type (e.g., Select Statement).
- Set the Variable Name to store the results of the query.
3. Add the JDBC Assertion:
- Right-click on the JDBC Request element and select Add -> Assertions -> Response Assertion.
- In the Assertion Control panel, select "JDBC Response Assertion" from the dropdown menu.
- Click on the "Add" button in the Patterns to Test section.
- Select "JDBC Variable" as the Field to Test and enter the variable name that stores the query results.
- Choose the appropriate Pattern Matching Rules and Patterns based on your data validation requirements.
4. Configure the Assertion:
- Specify the expected values or patterns in the Patterns to Test section.
- Choose the appropriate Assertion Test type (e.g., Contains, Equals, Matches, etc.).
- Set the Scope of assertion (e.g., Main sample only, Main sample and sub-samples, etc.).
5. Run the Test:
- Save your Test Plan and run the test in JMeter.
- JMeter will execute the SQL query and perform the assertion based on the configured rules.
- The test results will indicate whether the assertion passed or failed.
By using the JDBC Assertion, you can validate the data in your database during the test execution and determine if it meets your expected criteria. If the assertion fails, it indicates a mismatch or inconsistency in the data, allowing you to identify potential issues or errors.
Note: Ensure that you have the appropriate JDBC driver for your database installed and added to JMeter's classpath before using the JDBC elements.
Hi sir iam dedicatedly learning from your sessions,
I have a few questions here
What is response code 200 means?
Are these 15videos full corse
Can you please make a video for in real time what are the main features we use?
Please show us more APIs
Thanks a lot for all ur hard work and knowledge sharing
Hi, response code 200 is a success code, that means your request is received by the server and is correct and the server has also responded, now there are several codes in the series 2xx, you can see the list here - www.restapitutorial.com/httpstatuscodes.html
I have one query
I am working as a test manager and a automation tester + manual tester
Basically single tester in whole team
How we should show the test report to the stakeholders for both the manual and automation testcases and what are some of the KPI I can show to the team
Yes you can do based on the scenario and needs
@@RaghavPal
Hi Raghav,
Can you make a video , how these KPI will look using some reports.
Love every single video of yours
I will plan
Hi Raghav! Thanks for these AWESOME JMETER tutorials!! I plan to watch all of them this weekend. Can I just ask for 1 thing? Can you show how to write real-time results to a database? Mean how to right things such as http response time and assertions for each request into a database right after each one is returned? I know how to write MySQL db connections and queries but not sure where to write them in Jmeter and how to code to get the response information so I can write them into a variable to put into the MySQL code (I did something like this for my Selenium Java framework to show tests that passed, failed, are running, and still need to run). I plan to integrate the DB to a webpage I am making so that every few seconds it will query the test run as it is running, so I can see matrix number, such as if average response time is increasing or decreasing, how many hits have been made. So pretty much I will be making a monitoring tool to see live results/numbers as the test runs. Thanks!
Hi, I will plan to add a session on this
@@RaghavPal That would be Incredibly FABULOUS of you to do!! Thanks so much in advance!!
thank you.
Most welcome
Hi Raghav you said Assertion are applicable on response they why are we applying it on the request. I know this is a silly questions please clear it out for me
Hi Rohit, If I said that, it's incorrect and sorry for that, Assertions can be made on requests to, Assertions = Checks, and we can check both request and response
Hi Raghav waiting for the 7th Video
Coming soon Shoaib