• Saturday , 15 December 2018

JMeter Beginner Tutorial 6 – How to create a Database Test Plan

Code Canyon



Jmeter Beginner Tutorial 6 – How to create a Database Test Plan ==================================================== Step 1 – Add mysql jdbc jar …

Original source

3d Ocean

Related Posts

41 Comments

  1. Matheus Nicolas da Silva
    October 6, 2018 at 20:27

    can you explain the 10000 > 50000 max wait (ms)?

  2. Praveen Rumane
    October 6, 2018 at 20:27

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

  3. Arjun Singh
    October 6, 2018 at 20:27

    Thanks a lot Raghaw. So like that can we test DB for checking response time with peak load..???

  4. sumit kumar
    October 6, 2018 at 20:27

    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.

  5. sahana harish
    October 6, 2018 at 20:27

    Thank you so much for such a descriptive session, very helpful. Thanks for your effort.

  6. Shubham Girdhar
    October 6, 2018 at 20:27

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

  7. Sunil kumar
    October 6, 2018 at 20:27

    Hi Raghav, thanks for the help, can you please elaborate what is the purpose of adding mysql jdbc jar file to the jmeter?

  8. Faheem Khan
    October 6, 2018 at 20:27

    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

  9. Edison Jose
    October 6, 2018 at 20:27

    how to test on mongoDB ?

  10. Punit B
    October 6, 2018 at 20:27

    Hi Raghav,
    How to Connect the oracle DB?

  11. gausia fatima
    October 6, 2018 at 20:27

    Hey raghav,
    Is there any plugin available for cassandra and go database like there is one for mysql?

  12. NIDHI SHETTY
    October 6, 2018 at 20:27

    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.

  13. kiran deshmukh
    October 6, 2018 at 20:27

    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

  14. Fouziya Hanif
    October 6, 2018 at 20:27

    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.

  15. varun kumar
    October 6, 2018 at 20:27

    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 .

  16. Hindu reddy
    October 6, 2018 at 20:27

    please share the steps to create database

  17. Vedika Sharma
    October 6, 2018 at 20:27

    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?

  18. Slava Efimov
    October 6, 2018 at 20:27

    Your tutorials are very clear and helpful. Thanks a lot!!!

  19. MOHAMED SANNOH
    October 6, 2018 at 20:27

    Hi Raghav,
    Thanks for your great work . Could you please help in finding out database URL and the database you are currently using?

  20. abcd salma
    October 6, 2018 at 20:27

    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.

  21. captainCoolIndia
    October 6, 2018 at 20:27

    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.

  22. ayman smman
    October 6, 2018 at 20:27

    عراسي الحجي راجاف والله

  23. orientChaloo Oreo
    October 6, 2018 at 20:27

    hello, it is very good but needs some more explainination i think it's not been completely explained.

  24. sudhakaran ramalingam
    October 6, 2018 at 20:27

    Excellent work, What about Oracle DB?

  25. GeekTechZone
    October 6, 2018 at 20:27

    What should I put in "Query Type" in JDBC Request if my query is a insert or delete?

  26. Parveen Syed
    October 6, 2018 at 20:27

    how can i conect the mongodb conection in jmeter

  27. sudeshna banerjee
    October 6, 2018 at 20:27

    "Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL" – how to resolve this error?

  28. Shankar Ganesh
    October 6, 2018 at 20:27

    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.

  29. Hanan Butt
    October 6, 2018 at 20:27

    hi i m facing a problem i mailed you as well with my screenshots would you mind to have a look on them ?

  30. Muhammad Ali Khamis
    October 6, 2018 at 20:27

    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.

  31. Shweta Zullarwar
    October 6, 2018 at 20:27

    Hi raghav this tutorial is very nice and clear . will you please show how to use performance metric listner.

  32. Roman Denisenko
    October 6, 2018 at 20:27

    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…

  33. Roman Denisenko
    October 6, 2018 at 20:27

    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.

  34. Sudheer Chowdary Reddy Reddy
    October 6, 2018 at 20:27

    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?

  35. Kripal Bisht
    October 6, 2018 at 20:27

    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.

  36. Ashish Gupta
    October 6, 2018 at 20:27

    Excellent explanation and content. Thank you so much Raghav.

  37. Arun Vijeesh
    October 6, 2018 at 20:27

    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

  38. Pratik Rajput
    October 6, 2018 at 20:27

    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!

  39. Pratik Rajput
    October 6, 2018 at 20:27

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

  40. Deepak N
    October 6, 2018 at 20:27

    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.

  41. vinay rao
    October 6, 2018 at 20:27

    very nyc raghav

Leave A Comment

You must be logged in to post a comment.