JMeter Beginner Tutorial 9 – Database Test plan CreationDatabase performance testing in JMeter

preview_player
Показать описание
JMeter Beginner Tutorial 9 – Database Test plan Creation(Database performance testing) in JMeter
**********************************************************************************
Learning Agenda: Database Test plan Creation in JMeter.
Step 1 :
Restart JMeter
Step 2: Add Thread Group

Step 3: Add JDBC Conn Config | Provide the details of our DB

Step 4: Add JDBC Request

Step 5: Add Listeners - “View Results Tree” and “View Results in Table”

Step 6: Run and validate

Useful Tips:
General format for a JDBC URL for connecting to a MySQL server is as follows, with items in square brackets ([ ]) being optional: jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]] » ?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]

Example - Connection URL: jdbc:mysql://localhost:3306/databasename
*********************************************************************************************
Рекомендации по теме
Комментарии
Автор

FYI, In this tutorial the driver class is deprecated. I mean to say just replace this "com.mysql.jdbc.Driver" with "com.mysql.cj.jdbc.Driver". Although it will automatically cast to the latest Driver. Thanks by the way @HubWells .

mrtechnohaven