jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/foobar

GitHub | winston-lee | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Unable to find mysql jdbc driver

    GitHub | 8 months ago | winston-lee
    jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/foobar

    Root Cause Analysis

    1. jmeter.protocol.jdbc.config.DataSourceElement

      Could not return Connection java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/foobar

      at java.sql.DriverManager.getConnection()
    2. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:689)
      2. java.sql.DriverManager.getConnection(DriverManager.java:247)
      2 frames
    3. org.apache.avalon
      JdbcConnectionFactory.newInstance
      1. org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
      1 frame
    4. Excalibur Pool API
      ValidatedResourceLimitingPool.newPoolable
      1. org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
      2. org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
      2 frames
    5. org.apache.avalon
      ResourceLimitingJdbcConnectionPool.newPoolable
      1. org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:91)
      1 frame
    6. Excalibur Pool API
      ValidatedResourceLimitingPool.get
      1. org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
      2. org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
      2 frames
    7. org.apache.avalon
      ResourceLimitingJdbcDataSource.getConnection
      1. org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:188)
      1 frame
    8. org.apache.jmeter
      JDBCSampler.sample
      1. org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:286)
      2. org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:146)
      3. org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:85)
      3 frames
    9. Apache JMeter Core
      JMeterThread.run
      1. org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:434)
      2. org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:261)
      2 frames
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame