Error preloading the connection pool while running sql statement in Jmeter

Question

Error preloading the connection pool while running sql statement in Jmeter.

I am using below env:

• jdk1.8.0_151
• apache-tomcat-7
• commons-dbcp.jar (version: 2.1.1)
• commons-pool2-2.4.2
• apache-jmeter-3.1
• mysql-connector-java-5.1.45-bin

pfa jdbc connection,jdbc_request,request,response_data,sampler_result screenshots

Answer 1

I had a similar question when even 10 max connection settings in oracle caused errors. I suggest you use 0 value in JDBC's Maximum number of connections as recommended in JMeter JDBC manual:

Maximum number of connections allowed in the pool. In most cases, set this to zero (0).This means that each thread will get its own pool with a single connection in it, i.e. the connections are not shared between threads.