JMeter Beginner Tutorial 10 – How to create assertions for JDBC (Database) Test Plan

Notes:

to watch before this video : Jmeter Beginner Tutorial 6 – How to create a Database Test Plan

Step 1
Add a Response Assertion


Step 2
Add variable names in JDBC Request

Col1,Col2,Col3,Col4

Col1 Col2 Col3 Col4
=== === === ===
ID Name Age Country
1 Raghav 30 India
2 Tom 40 New Zealand

Col4_2 = NewZealand
Col2_2 = Tom


Step 3
In Response Assertion add Jmeter Variable and Pattern to Test


Step 4
Add Listener Assertion Results


Step 5
Run and validate


JMeter Beginner Playlist : https://www.youtube.com/playlist?list…

JMeter Intermediate Playlist : https://www.youtube.com/playlist?list…

JMeter Advanced Playlist: https://www.youtube.com/playlist?list…

 

Send me your comments and feedback


 

0