JMeter Tutorials | 07 | Testing a DB using Jmeter | Sampler|JDBC request |BeanShell assertions|Tamil
9.4 هزار بار بازدید -
5 سال پیش
-
Jmeter provides us with a
Jmeter provides us with a lot of options to test various components like HTTP services, FTP servers and databases etc. In this video, we are going to learn how to test a database with JMeter.
JDBC Request: So far we have seen, HTTP request sampler and validating them with different types of assertions and viewing the results in different listener formats. The next important sampler type will be JDBC request.
To do this test we need a database. Installing a DB like an oracle SQL or MySQL will take more time. So, we are going to follow the same approach we did for doing our JDBC example. We are going to use XAMPP. Please refer the Must Know JAVA concepts | Selenium Automation | PART - 1 | Working with Databases video for clear understanding.
Video Link: Must Know JAVA concepts | Selenium Au...
Installation Reference links:
---------------------------------------------
1)Download URL for XAMPP - https://bit.ly/1lmUscR
2) How to install Xampp - How to Install XAMPP Server on Window...
3) Create database and table in MySQL - create a database with xampp
4) JDBC connector Jar for MySQL - https://bit.ly/2VXDEl2
Else, you can sign up with https://www.db4free.net/ site and create a DB straightaway without setting up anything on your machine. Either way, it’s your choice.
Data to be given in Connection Configuration:
Database URL: "jdbc:mysql://localhost:3306/selenium_users",
Driver class: com.mysql.cj.jdbc.Driver
We have to add the JAR as well for Mysql. Mysql-connector-java-8.0.13
BeanShell Assertion:
We can use BeanShell assertion for writing our own customised logic to validate the results.
Watch my other videos:
1)Selenium basics: http://bit.ly/2XtOt1F
2)Selenium Advanced: http://bit.ly/2WYieZe
3)TestNG Absolute Beginner Guide: http://bit.ly/2N6xgaM
4)Data-driven framework: http://bit.ly/2WVjSFT
5)Page Object Model: http://bit.ly/2IAXJZR
6)How to write XPath on our own: http://bit.ly/2KwMLql
7)Must know Java concepts for Selenium: http://bit.ly/31Ro7G8
8)Selenium Interview Questions: http://bit.ly/2N6xu1F
9)Java for Selenium Automation: http://bit.ly/2IylOAh
10)Maven beginner guide: http://bit.ly/2Rsigm0
11)Github Absolute beginner Guide: http://bit.ly/2Kxdzqj
12)REST Web services beginner guide: http://bit.ly/2N69rQq
13)Cucumber absolute beginner guide: http://bit.ly/2X0lSBB
14)Acceptance Testing (Fitnesse) beginner guide: http://bit.ly/2Y6oE55
15)Jenkins beginner guide: http://bit.ly/2X39fGb
#PerformanceTesting #JMeter #LAO #Tamil
JDBC Request: So far we have seen, HTTP request sampler and validating them with different types of assertions and viewing the results in different listener formats. The next important sampler type will be JDBC request.
To do this test we need a database. Installing a DB like an oracle SQL or MySQL will take more time. So, we are going to follow the same approach we did for doing our JDBC example. We are going to use XAMPP. Please refer the Must Know JAVA concepts | Selenium Automation | PART - 1 | Working with Databases video for clear understanding.
Video Link: Must Know JAVA concepts | Selenium Au...
Installation Reference links:
---------------------------------------------
1)Download URL for XAMPP - https://bit.ly/1lmUscR
2) How to install Xampp - How to Install XAMPP Server on Window...
3) Create database and table in MySQL - create a database with xampp
4) JDBC connector Jar for MySQL - https://bit.ly/2VXDEl2
Else, you can sign up with https://www.db4free.net/ site and create a DB straightaway without setting up anything on your machine. Either way, it’s your choice.
Data to be given in Connection Configuration:
Database URL: "jdbc:mysql://localhost:3306/selenium_users",
Driver class: com.mysql.cj.jdbc.Driver
We have to add the JAR as well for Mysql. Mysql-connector-java-8.0.13
BeanShell Assertion:
We can use BeanShell assertion for writing our own customised logic to validate the results.
Watch my other videos:
1)Selenium basics: http://bit.ly/2XtOt1F
2)Selenium Advanced: http://bit.ly/2WYieZe
3)TestNG Absolute Beginner Guide: http://bit.ly/2N6xgaM
4)Data-driven framework: http://bit.ly/2WVjSFT
5)Page Object Model: http://bit.ly/2IAXJZR
6)How to write XPath on our own: http://bit.ly/2KwMLql
7)Must know Java concepts for Selenium: http://bit.ly/31Ro7G8
8)Selenium Interview Questions: http://bit.ly/2N6xu1F
9)Java for Selenium Automation: http://bit.ly/2IylOAh
10)Maven beginner guide: http://bit.ly/2Rsigm0
11)Github Absolute beginner Guide: http://bit.ly/2Kxdzqj
12)REST Web services beginner guide: http://bit.ly/2N69rQq
13)Cucumber absolute beginner guide: http://bit.ly/2X0lSBB
14)Acceptance Testing (Fitnesse) beginner guide: http://bit.ly/2Y6oE55
15)Jenkins beginner guide: http://bit.ly/2X39fGb
#PerformanceTesting #JMeter #LAO #Tamil
5 سال پیش
در تاریخ 1398/04/05 منتشر شده
است.
9,491
بـار بازدید شده