In Jmeter Cannot create PoolableConnectionFactory

Question

I am trying to run select query in jmeter. I am getting this response in listners "Cannot create PoolableConnectionFactory" I have attached my myphpadmin page which I use to create db. Thanks in advance.

.png

Answer 1

JDBC jar should be in lib folder:

Fully qualified name of driver class. (Must be in JMeter's classpath - easiest to copy .jar file into JMeter's /lib directory).

I assume you use your jar for MySQL DB:

The list of the validation queries can be configured with jdbc.config.jdbc.driver.class property and are by default:

MySQL com.mysql.jdbc.Driver

Answer 2

1. You need to put the .jar into the "lib" folder of your JMeter installation (or other folder which is in JMeter Classpath
2. You need to restart JMeter to pick the .jar

Check out MySQL Database and JMeter - How to Test Your Connection for more information