About this question
When running jmeter script for JDBC connection giving below error how can i resolve it? Jmeter bamboo log - SQLException: Cannot create PoolableConnectionFactory
When running jmeter script for JDBC connection giving below error how can i resolve it? Jmeter bamboo log - SQLException: Cannot create PoolableConnectionFactory
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Cyber Security Expert
Answered on Feb 24, 2022
Cannot create poolableconnectionfactory means that JDBC Driver used by JMeter to establish connection with the database fails to communicate over the existing connection.
The reasons could be in: Version mismatch of the JDBC driver and the database, double check it and update/downgrade your JDBC driver
You are leaving connections open for a long amount of time hence database is running out of the available connections in the pool. Either increase open connections limit on the database side or ensure that connections are being closed at least on JMeter side. Your database server is overloaded therefore it cannot accept incoming connections anymore. Check database logs files for any suspicious entries. You can additionally ensure that it has enough headroom to operate using i.e. JMeter PerfMon Plugin And last but not the least, be aware that since JMeter 3.1 it is recommended to use JSR223 Test Elements and Groovy language so consider migrating your Beanshell test elements to JSR223 ones on the next available opportunity.
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Cyber Security guides from industry experts
Common Cyber Security interview questions, answered
Guides, tips and career advice on Cyber Security from JanBask experts.
Cyber Security Ethical Hacker Roles and Responsibilities: What Do Ethical Hackers Actually Do?
What does an ethical hacker actually do? See the five-phase process, daily tasks, required skills, and where ethical hackers work.
Cyber Security Penetration Tester Roles and Responsibilities: What Does a Pen Tester Do?
Learn what a penetration tester does, including key roles, responsibilities, daily tasks, tools, skills, reporting, and…
Cyber Security GRC Analyst Roles and Responsibilities: What Does a GRC Analyst Do?
What does a GRC analyst actually do? See the core responsibilities, how they grow by experience level, a daily routine, tools,…
Cyber Security SOC Analyst Roles and Responsibilities: What Does a SOC Analyst Do?
What does a SOC analyst actually do? Explore core responsibilities, the Tier 1–3 structure, daily tasks, tools, and skills in…