JMeter tutorial 15 - Database performance testing | How to create Database Test Plan | JDBC Request
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- This video covers how to perform Database performance testing in JMeter
Learning:
We must have below database parameters with us before moving on to JMeter to test database:
• Server name
• Port number
• Username, password
• Permission to do action (create, update, delete etc) in db
Steps to test database using JMeter
Step1: Add mysql connector jar to lib folder of JMeter and restart JMeter
Step2: Make connection with database by adding config element - JDBC Connection Configuration(to configure JMeter connection with database) and provide details in JDBC Connection Configuration page
Database url:
Format: jdbc:mysql://servername:portnum/schemaName
example: jdbc:mysql://localhost:3306/new_schema
Step 3: write sql query
• Add jdbc sampler request
• Write sql query
Step 3: execute the test and validate the results
==================================================================
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
Subscribe for more tutorials - / @qualityassurancelab7764
Your Entire tutorial is very much helpful. Thank you for putting across. Appriciated your efforts
Excellent explanation.Thank you so much.
Tq soooooo much...... the way of ur explanation is awesome mam
Best Video i have seen on JDBC.. +1 Thumps up !!
Superb explanation ❤
very very nice explanation mam
This is awesome and helps a lot. Thanks. Query: for getting the data with select statement, do we need update access to DB?
You are welcome, update access is not required for select statement
It's really helped a lot...thank u👏
Please record and upload in at least 1080. Impossible to read what you are typing here @19:16 in green font, even when I am using a 4K 27" monitor.
Hello..Thank you for the excellent explanation. Simple and Clear. Appreciate your efforts.
I have a question. Do you have a tutorial on how you created the tables in mysql workbench. If yes, please share.
Thanks, glad that you liked the video. I have not created such video, I'll plan for the same
Hi excellent explanation mam.i follow your videos for studying jmeter.very easy to follow.
Mam i was trying to create a database but i didnt find the link for creating db in the description. Can u please help
Is there a way to do a teardown of the test? Say you are doing an insert but you want to delete that inserted row
Hi..want to execute multiple sql queries and export output data in csv how to do...? Could u pls guide
This is awesome. Question : I want to check the execution time of a update query. But I cannot make changes in original schema. Can you suggest what can I do?
HI Can you let me know how to check the mongobd and Redshift using jmeter tool, to capture the stress on data base side on adding data on front end
I am getting below error
Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL ' jdbc:mysql://localhost:3306/Employee'
Can you please help me to fix it?
Hi, have you hosted your database at localhost:3306 ?
@@qualityassurancelab7764Yes i am using mysql database on localhost. so it's a 3306
Ma'am are you to planning to launch any course on Java Selenium ? Because the way you teach i think if you launch that course it will be very helpful for all of us. as Selenium is very high in demand. looking to hear from you.
Suppose we have one HTTP request which is expecting json files as input and it is taking that from some path and creating some data in DB and based on the size of JSON file it will take more time to get the status of the record to be completed in DB. How can we have a track how much time it is taking for all the samples to compete, suppose we ran for 20 threads with 10 jsons?
In Jmeter it is showing it is showing status SUCCESS but in DB that work is still in IN PROGRESS state. Is there any way we can make that sample to PASS in Jmeter once the status in DB is complete?
What if I want to pull values from any file and it should execute query with all values from that file
Hi, in that case, you can put your values in CSV file and use the Config element - "CSV Dataset Config" to fetch values from csv file, i.e. you need to use the concept of parameterization here. For more details, please refer - th-cam.com/video/mrmnos1eMKk/w-d-xo.html
You mention variable name where you taken the variable value
This is really helping us a lot.I would like to use a field value from the database table generated as a response from jdbc request.Could you please suggest how can I do it. @quality assurance lab
Hi , can you please leave the link to "How to create my sql database
"
I am using mysql default settings. username root and password -empty string.How to set this in jmeter?
In the Config Element -> JDBC Connection Configuration, under Database Connection Configuration section, you can set your Username and Password.
Hello... How can RDS Database with Jmeter? We have tried to connect RDS endpoint in the Database URL but got an error like Cannot create PoolableConnectionFactory (Socket fail to connect to host:address
Can we generate performance of any procedure..how to perform performance testing for any procedure.pls explain wid demo ...🙏🙏
Yes, we can do so. Please follow the steps below under JDBC Request:
Put the query as call_procedureName (?,?,?) ; '?' is provided as many number of times as the number of parameters
Provide ParameterValue as Comma-separated list of parameter values ; Use Null to indicate a NULL parameter.
Provide ParameterType as Comma-separated list of SQL parameter types(e.g. INTEGER, DATE, VARCHAR, DOUBLE)
If callable statement has INOUT or OUT parameters, then these must be indicated by prefixing the appropriate parameter types, e.g. instead of "INTEGER", use "INOUT INTEGER"
Hope that helps, please let me know for any further query.
Thanks ...your videos are very helpful for me to learn jmeter.. let me try this...I will get back to you...
I'm using jumpbox to connect database and password will change every time.. could u pls tell me how to configure dynamic password and integrate in jdbc connection configuration in jmeter.
How to fix data base ‘ready only’ issue in phpmyadmin while updating from phpmyadmin also from jmeter tool same issue. Please help
Thanks
Need help for this issue I’m not able to insert data. While saving displays error message database is ‘read only’
@@farazshaikh3654 Seems like you do not have write permission. Open database properties --> options and set Database read-only to False and try again
I want to generate random data while inserting to db. Hows that possible?
He'll Ma'am,
Thanks for the guide. My question is how to connect with oracle database. Can you suggest me the video or steps for it. I had my try but not success.
Through jdbc
We are using robot 3t . How to connect.
Hi,
While implementing I am an encountered with this below error could you help me out in this
Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'com.mysql.jdbc.Driver'@'106.200.254.129' (using password: YES))
Hi, could you please share the Database URL provided under JDBC Connection configuration?
yes sure
Database URL : jdbc:mysql://db4free.net:3306/jmeterdb_test
Hey,
This issue is resolved . Thanks ...!!!
@@gunjanattri7365 what was the problem? have the same one.
@gunjananttri7365
How did u resolve? I am facing the same issue. Making connection with sql server local host. Ur kind support please.
Hi Ma'am,
Nice explanation. I have done this earlier, but in my case I need to add the query result (Set of IDs) to payload in post request. How can I do that? Thanks.
how to load data in database ?
Hello i wanna ask for set username and password in Jmeter. Its up to me or no?
Thankyou
Username : root
Password: No
Try this it works fine for me
@@farazshaikh3654 you set the username and password its up to you or not?
@@syendinazera2483 it’s by default if you want to change you can change after login. Btw i’m using phpmyadmin database
HI! Oh my goodness. Please do not shout. You're voice is piercing high and hurts my ears. invest in a good microphone and speak a little slower.
Excellent explanation.Thank you so much.