JMeter Beginner Tutorial 12 - How to create assertions for JDBC (Database) Test Plan

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

________ ONLINE COURSES TO LEARN ________

------------ UI TESTING ------------

------------ API TESTING ------------

------------ MOBILE TESTING ------------

------------ CI | CD | DEVOPS ------------

------------ VERSION CONTROL SYSTEM ------------

------------ PERFORMANCE TESTING ------------

------------ PROGRAMMING ------------

------------ IDE ------------

------------ MAVEN ------------

------------ OTHERS ------------

----------- Connect with Raghav ------------

You can support my mission for education by sharing this knowledge and helping as many people as you can.

Never Stop Learning
Raghav

[brpctips]

thank you...thank you ...thank you so much !!!! i really spend all day search a solution for my problem, and you help me to solved it.

[slobodanparizoski]

It is useful to add a debug sampler and with it, you can see all variables and their values after the test script is run.

[saair]

Thanks raghav for sharing a series,
I have no programming background but a programming concepts and I was worried how do I learn automation but thanks to you to making it easy for manual testers like me to learn automation and boost their career.

We can give a lots of prayers and thanks in guru dakshana :)

Keep it up raghav!

[murtazamansoor]

Hey Raghav, thanks for such excellent tutorials, I don't think that there's could not be more simpler and brief tutorials on JMeter.
Can you please do a series on Serenity BDD framework.

[chetannandimath]

Hi Raghav, very impressive videos...thanks a lot...please post some videos on BDD(cucumber) automation and selenium-3

[meghnagandhi]

Hi Raghav, first of all excellent videos. your simplicity in language and liquidity just hold on us till end.. so keep it up. And thanks for making these excellent videos. I also request you that will you please give me link to find how to create database(open)

[muhammadshakir]

Thanks for such a excellent tutorial, but i have little bit confusion how can i pass more than 2 variables and pattern to test.

[KedarnathDongre]

Fan of your videos. Thanks for sharing Raghav!

[Krishy]

Hello @Raghav Pal, Thank you very much for your fabulous videos. I tried your example but when i used Col2_4 in my test plan i am getting Response was Null. Can you please give your inputs?

[avinashpenugonda]

Hi Raghav, Thank You for the wonderful videos.

I got a question.

I want to assert the column headings from my response. How can I do that. I tried it by providing Col1, Col2, Col3 in the Variable name of sampler and Col1_0 as the variable name to use in response assertion and the Column name under Patterns to use. but I am seeing Response was Null. Can you help me in fixing this.

[medhabhattacharya]

Hey Raghav, thanks for such excellent tutorials. Can you please do a video for oracle database

[noumank.j.]

Why we are not using ${varname} while defining variables in jdbc? Usually we use ${varname} format to define a variable, Why not here?

[kalyanisatyavolu]

Hi Raghav, Your videos are very helpful:) Do you know how I can extract the dynamic value received from the JMS Subscriber Response and fetch the same in the second JMS Publisher? Thanks!!

[yamica]

Hi Raghav. I try many times to connect to mysql but not successful. Can you help me?
shown message: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL '

[nikhilarora]

sir please teach me how can i run the the threadgroup only from command save its data only in csv file not at in jmeter

[victorsen]

Hi,

How to test multiple assertions for a single column having different values in different rows.

[hppatel]

Hello Raghav,
how to handle empty value returned by jdbc sql query. It is storing null value as a variable name. e.g.: ${Database_Column_Name_1}
Can you please help me how do I manage return emopty value using JSR223? Appreciate your help.
Thank you in advance!

[nilava]

Hi Raghav, very nice videos, doing good job. but I have one query ?? How to parameterized DB value.. Suppose I have 10000 username in my excel sheet, and same username in DB. So all 10000 username should take from my DB and also it will check with excel sheet and will be valided in DB.
Please provide this configuration and step also

[tejaswinipawar]

hello sir, ,

database testing ka use kya hai exactly...means can we know the detail normalization DB/load on your video we r just fetching data in jmeter, , , ,

but uska use kya hai?

[jagadeeshtummalacharla]

Hi Raghav, very nice video. I want to ask you one question.

When we get respone of an API which is JSON response.
1. I want to store whole response into one variable( letsay ex: arraylist)
2. Now I want to fetch the expected data from database and again store it into one variable(le'ts say data structure ex: arraylist)
3. Now i want to compare the actual data is equal to the expected data or not !


can you help me how to achieve this