CODEWITHSUNDEEP
javajmeter
Durairaj s
Durairaj s

Reputation: 193

In Jmeter Cannot create PoolableConnectionFactory

enter image description hereenter image description hereI 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.

enter image description here.png

enter image description here

Upvotes: 4

Views: 9689

Answers (3)

UBIK LOAD PACK
UBIK LOAD PACK

Reputation: 34566

On JMeter side check:

  • driver of MySQL (correct version) is in lib folder. The Jar not a zip.
  • The URL format is correct based on this document, there seems to be a space before database name in your URL
  • Login / password are also correct, check for strange characters or bad copy/paste

If all those are ok, then you're most probably facing same issues as the ones described here:

Upvotes: 1

Dmitri T
Dmitri T

Reputation: 168197

  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

Upvotes: 1

Ori Marko
Ori Marko

Reputation: 58882

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

Upvotes: 1

Related Questions