← All Prompt Categories

📚 LLM HUB · 2 PROMPTS

Database & JDBC Testing

2 copy-ready AI prompts for database & jdbc testing in JMeter, k6, and Gatling. Part of the JMeter.AI LLM Hub.

JMeter JDBC Load Test

Generate a JMeter JDBC test plan for database performance testing:

Database: [MySQL / PostgreSQL / Oracle / SQL Server]
JDBC URL: [jdbc:mysql://localhost:3306/testdb]
Driver class: [com.mysql.cj.jdbc.Driver]
Username/password: parameterized via CSV

Queries to test:
1. SELECT: [your query]
2. INSERT: [your query]
3. UPDATE: [your query]

Include:
- JDBC Connection Configuration element
- JDBC Request sampler for each query
- Result variable extraction for SELECT results
- Connection pool settings (maxActive, maxIdle, maxWait)
- Proper connection cleanup
- Full JMX XML output

Connection Pool Exhaustion Diagnosis

During my load test, I'm seeing errors like:
"Cannot get a connection, pool error: Timeout waiting for connection"
OR
"HikariPool - Connection is not available, request timed out after Nms"

Diagnose and fix:
- What is connection pool exhaustion and why does it happen under load?
- How to calculate the right pool size for my workload
- HikariCP configuration best practices (minimumIdle, maximumPoolSize, connectionTimeout, idleTimeout)
- Spring Boot application.properties settings
- How to monitor connection pool in Grafana/Prometheus
- What to look for in slow query logs