Jmeter Beginner Tutorial 6 – How to create a Database Test Plan ==================================================== Step 1 – Add mysql jdbc jar …
Original source
Link to this post!
JMeter Beginner Tutorial 6 – How to create a Database Test Plan
Jmeter Beginner Tutorial 6 – How to create a Database Test Plan ==================================================== Step 1 – Add mysql jdbc jar …
Original source
41 responses to “JMeter Beginner Tutorial 6 – How to create a Database Test Plan”
can you explain the 10000 > 50000 max wait (ms)?
Hi Raghav Iam getting this error while running
Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:myql://db4free.net:3306/myfirstsql'
2018-08-23 00:16:23,509 INFO o.a.j.e.StandardJMeterEngine: Running the test!
2018-08-23 00:16:23,511 INFO o.a.j.s.SampleEvent: List of sample_variables: []
2018-08-23 00:16:23,521 INFO o.a.j.g.u.JMeterMenuBar: setRunning(true, *local*)
2018-08-23 00:16:23,547 INFO o.a.j.e.StandardJMeterEngine: Starting ThreadGroup: 1 : Thread Group
2018-08-23 00:16:23,548 INFO o.a.j.e.StandardJMeterEngine: Starting 1 threads for group Thread Group.
2018-08-23 00:16:23,549 INFO o.a.j.e.StandardJMeterEngine: Thread will continue on error
2018-08-23 00:16:23,549 INFO o.a.j.t.ThreadGroup: Starting thread group… number=1 threads=1 ramp-up=1 perThread=1000.0 delayedStart=false
2018-08-23 00:16:23,551 INFO o.a.j.t.ThreadGroup: Started thread group number 1
2018-08-23 00:16:23,551 INFO o.a.j.e.StandardJMeterEngine: All thread groups have been started
2018-08-23 00:16:23,556 INFO o.a.j.t.JMeterThread: Thread started: Thread Group 1-1
2018-08-23 00:16:23,561 INFO o.a.j.t.JMeterThread: Thread is done: Thread Group 1-1
2018-08-23 00:16:23,561 INFO o.a.j.t.JMeterThread: Thread finished: Thread Group 1-1
2018-08-23 00:16:23,562 INFO o.a.j.e.StandardJMeterEngine: Notifying test listeners of end of test
2018-08-23 00:16:23,563 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false, *local*)
Thanks a lot Raghaw. So like that can we test DB for checking response time with peak load..???
Hi Raghav I really like your videos and its very helpful at the same time. I have one request, Can you please create a video or give me some reference for testing MongoDB in Jmeter? It will be really helpful Thanks.
Thank you so much for such a descriptive session, very helpful. Thanks for your effort.
Sir i am getting below error please help
2018-07-30 20:07:21,673 INFO o.a.j.e.StandardJMeterEngine: Running the test!
2018-07-30 20:07:21,675 INFO o.a.j.s.SampleEvent: List of sample_variables: []
2018-07-30 20:07:21,756 INFO o.a.j.g.u.JMeterMenuBar: setRunning(true, *local*)
2018-07-30 20:07:21,910 INFO o.a.j.e.StandardJMeterEngine: Starting ThreadGroup: 1 : Thread Group
2018-07-30 20:07:21,910 INFO o.a.j.e.StandardJMeterEngine: Starting 1 threads for group Thread Group.
2018-07-30 20:07:21,910 INFO o.a.j.e.StandardJMeterEngine: Thread will continue on error
2018-07-30 20:07:21,910 INFO o.a.j.t.ThreadGroup: Starting thread group… number=1 threads=1 ramp-up=1 perThread=1000.0 delayedStart=false
2018-07-30 20:07:21,911 INFO o.a.j.t.ThreadGroup: Started thread group number 1
2018-07-30 20:07:21,911 INFO o.a.j.e.StandardJMeterEngine: All thread groups have been started
2018-07-30 20:07:21,913 INFO o.a.j.t.JMeterThread: Thread started: Thread Group 1-1
2018-07-30 20:07:21,936 INFO o.a.j.t.JMeterThread: Thread finished: Thread Group 1-1
2018-07-30 20:07:21,936 ERROR o.a.j.JMeter: Uncaught exception:
java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z
at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:916) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:282) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:362) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2340) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2323) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2056) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:326) ~[ApacheJMeter_jdbc.jar:4.0 r1823414]
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:191) ~[ApacheJMeter_jdbc.jar:4.0 r1823414]
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:79) ~[ApacheJMeter_jdbc.jar:4.0 r1823414]
at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:490) ~[ApacheJMeter_core.jar:4.0 r1823414]
at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:416) ~[ApacheJMeter_core.jar:4.0 r1823414]
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:250) ~[ApacheJMeter_core.jar:4.0 r1823414]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
2018-07-30 20:07:21,941 INFO o.a.j.e.StandardJMeterEngine: Notifying test listeners of end of test
2018-07-30 20:07:21,942 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false, *local*)
Hi Raghav, thanks for the help, can you please elaborate what is the purpose of adding mysql jdbc jar file to the jmeter?
Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
this error is not resolved please help me
restart jmeter but can not resolve this issue
how to test on mongoDB ?
Hi Raghav,
How to Connect the oracle DB?
Hey raghav,
Is there any plugin available for cassandra and go database like there is one for mysql?
Hi Raghav,
i have given my database url as:"jdbc:mysql://localhost:8888/nidhisdb".And i have even loaded mysql.jdbc driver in the lib folder.
But i am getting this error on execution:Cannot create PoolableConnectionFactory (Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
Can u pls explain.
Hi Raghav,
I have xampp on my local server.I created database on xampp but while performing test through jmeter it is showing
Response message: java.sql.SQLException: Cannot create PoolableConnectionFactory (null, message from server: "Host 'KIRAN-PC' is not allowed to connect to this MariaDB server") how to fix it???? I provide valid credential's
I m finding the restart button still I m struggling on that Jar added on lib folder of Jmeter. Currently I m using Apache Jmeter4.0 where i have to find RESTART BUTTON.
2. Does DB testing suits for Micro Soft Visual Studio. Kindly, share the URL.
Thanks in Advance.
Hi Raghav,
i was trying this , but i am getting Response message: java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link failure) can u pls help.
may i know ur mail id ,so that i can contact you .
please share the steps to create database
Hi Raghav , Thanks for tutorial , but I am getting error while establishing jdbc connection. "Response message: java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)" Could you please help?
Your tutorials are very clear and helpful. Thanks a lot!!!
Hi Raghav,
Thanks for your great work . Could you please help in finding out database URL and the database you are currently using?
Hi raghav…I am getting the below exception on executing JDBC script.
Error Count: 1
Data type ("text"|"bin"|""): text
Response code: null 0
Response message: java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
Can you please help me out?
JDBC jar file I have added to the Jmeter lib folder too. Then I have restarted the J meter.
Worst speed on db4free.net... Unable to login to create a database table for demo script. Public is fine but if one is not capable to give a moderate speed they should close services rather.
عراسي الحجي راجاف والله
hello, it is very good but needs some more explainination i think it's not been completely explained.
Excellent work, What about Oracle DB?
What should I put in "Query Type" in JDBC Request if my query is a insert or delete?
how can i conect the mongodb conection in jmeter
"Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL" – how to resolve this error?
Hi Raghav,
Many Thanks for your Jmeter tutorial videos. So far I completed and practiced 6 videos successfully (from 1 to 6). I too have some questions to make myself more clear. Kindly share your email id to shankar.ganesh@ust-global.com
Waiting for your mail.
hi i m facing a problem i mailed you as well with my screenshots would you mind to have a look on them ?
Hi Raghav,
1. Is there anyway to display Response Data properly. Due to thousands of records, all data messed up.
2. How can I see in results number of rows returned executed by select query.
Hi raghav this tutorial is very nice and clear . will you please show how to use performance metric listner.
Raghav, I solved this problem when I uploaded new mysql-connector-java-5.0.8-bin but now I have other problem. Sampler results tree contains notification: "Response message: java.sql.SQLException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'sql11.freesqldatabase.com' " I set the JDBC connection configuraton according to your instructions…
Raghav, please help. I got some error : Cannot load JDBC driver class 'com.mysql.jdbc.Driver' but set all fields according to your instructions http://prntscr.com/gnpjgf I installed MySQL server and MySQL workbench for testing standalone DB on my PC. All is OK. If you can explain how can I fix this problem I will be very happy. Thanks.
Hi Raghav,
I have a query. Does every post request that we hit to server with 10 thread groups or users will get inserted into the Database? Can you please explain me with this query as soon as possible?
Hi Raghav…….can you please help me in finding any free db like db4free.net.…..coz i find db4free very slow…..i need this just to practice.
Excellent explanation and content. Thank you so much Raghav.
Hi Nice videos, Thanks Ragav
Can you just tell how to record the script for mobie apps
also is there any videos advanced j meter
appreciate your help on some small thing:
I need to extract from DB a user and a password in order to pass them as parameters within HTTP request. please specify the step .
For some reason what I do at the moment I fail miserably.
Many thanks in advance!
Hi , i have sign up page having otp field..after enter the first name mob no in mob no field , i click on verify button ,it send a otp in database ..and i want to input this otp on sign up from for completing signup ptocess .how can it is possible performance test of this scenario in case of mupltiple users ..
Hey, Can I Switch between different databases to test the performance of the web app to check response with different volume of db in Jmeter,
Please someone reply me.
very nyc raghav