JMeter tutorial 15 - Database performance testing | How to create Database Test Plan | JDBC Request

[@hirakjyotikakati4734]

Your Entire tutorial is very much helpful. Thank you for putting across. Appriciated your efforts

[@mehlover]

Super helpful! Thanks for making this!

[@MultiDpz]

Best Video i have seen on JDBC.. +1 Thumps up !!

[@barkatthemoonlunatic1715]

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.

[@hkasturi2582]

Tq soooooo much...... the way of ur explanation is awesome mam

[@roshanp.thomas1768]

Excellent explanation.Thank you so much.

[@LearnTogether-Tamil]

Super explanation

[@HiraTariq-pi5ov]

Superb explanation ❤

[@kartikkurbar9616]

It's really helped a lot...thank u👏

[@nareshgarg6347]

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

[@suryakasc9093]

very very nice explanation mam

[@ravik6092]

This is awesome and helps a lot. Thanks. Query: for getting the data with select statement, do we need update access to DB?

[@qualityassurancelab7764]

You are welcome, update access is not required for select statement

[@kevinlao3690]

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

[@neelimapatnaik4327]

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

[@sheetalchauhan39]

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?

[@zc8497]

Is yugabyte db load testing possible in jmeter?

[@gopinathkrish1191]

Hi..want to execute multiple sql queries and export output data in csv how to do...? Could u pls guide

[@asisharavind655]

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.

[@qualityassurancelab7764]

Thanks, glad that you liked the video. I have not created such video, I'll plan for the same

[@askanivijay6978]

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.

[@salmansrabon9799]

I want to generate random data while inserting to db. Hows that possible?

[@remforde2767]

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?

[@qualityassurancelab7764]

Hi, have you hosted your database at localhost:3306 ?

[@remforde2767]

@@qualityassurancelab7764Yes i am using mysql database on localhost. so it's a 3306

[@prachichandola4546]

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?

[@pradyumnavaradpande3688]

What if I want to pull values from any file and it should execute query with all values from that file

[@qualityassurancelab7764]

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 - kzbin.info/www/bejne/o6PQn6KpZsqAgc0

[@bobogadlela1362]

I am using mysql default settings. username root and password -empty string.How to set this in jmeter?

[@qualityassurancelab7764]

In the Config Element -> JDBC Connection Configuration, under Database Connection Configuration section, you can set your Username and Password.

[@berrypallavi]

Hi , can you please leave the link to "How to create my sql database "

[@gunjanattri7365]

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))

[@qualityassurancelab7764]

Hi, could you please share the Database URL provided under JDBC Connection configuration?

[@gunjanattri7365]

yes sure Database URL : jdbc:mysql://db4free.net:3306/jmeterdb_test

[@gunjanattri7365]

Hey, This issue is resolved . Thanks ...!!!

[@kajetanmellerowicz8004]

@@gunjanattri7365 what was the problem? have the same one.

[@Belalakhtar]

@gunjananttri7365 How did u resolve? I am facing the same issue. Making connection with sql server local host. Ur kind support please.

[@farazshaikh3654]

How to fix data base ‘ready only’ issue in phpmyadmin while updating from phpmyadmin also from jmeter tool same issue. Please help Thanks

[@farazshaikh3654]

Need help for this issue I’m not able to insert data. While saving displays error message database is ‘read only’

[@qualityassurancelab7764]

@@farazshaikh3654 Seems like you do not have write permission. Open database properties --> options and set Database read-only to False and try again

[@LoveUPes]

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.

[@abhijith4245]

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

[@shikhabopche6066]

Can we generate performance of any procedure..how to perform performance testing for any procedure.pls explain wid demo ...🙏🙏

[@qualityassurancelab7764]

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.

[@shikhabopche6066]

Thanks ...your videos are very helpful for me to learn jmeter.. let me try this...I will get back to you...

[@sreenin9746]

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

[@pratheepkumar4218]

We are using robot 3t . How to connect.

[@shyamreddy8219]

You mention variable name where you taken the variable value

[@cashedhaka3766]

how to load data in database ?

[@nileshthummar20]

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.

[@arnavpatil583]

Through jdbc

[@syendinazera2483]

Hello i wanna ask for set username and password in Jmeter. Its up to me or no? Thankyou

[@farazshaikh3654]

Username : root Password: No Try this it works fine for me

[@syendinazera2483]

@@farazshaikh3654 you set the username and password its up to you or not?

[@farazshaikh3654]

@@syendinazera2483 it’s by default if you want to change you can change after login. Btw i’m using phpmyadmin database

[@nasruddinshaik6893]

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.

[@barkatthemoonlunatic1715]

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.

[@jariwala__parth]

Excellent explanation.Thank you so much.