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?
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.
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
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, 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
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.
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?
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?
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.
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.
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
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.
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 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.
Your Entire tutorial is very much helpful. Thank you for putting across. Appriciated your efforts
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.
Tq soooooo much...... the way of ur explanation is awesome mam
Best Video i have seen on JDBC.. +1 Thumps up !!
Excellent explanation.Thank you so much.
very very nice explanation mam
Super helpful! Thanks for making this!
Super explanation
Superb explanation ❤
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
It's really helped a lot...thank u👏
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
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
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
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.
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
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.
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
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
Hi..want to execute multiple sql queries and export output data in csv how to do...? Could u pls guide
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
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...
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?
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?
I want to generate random data while inserting to db. Hows that possible?
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.
Hi , can you please leave the link to "How to create my sql 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
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.
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
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.
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
how to load data in database ?
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.
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.