ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question
During code review of a Java payment microservice, you find each REST call opens a new JDBC connection and closes it only on success, leaving failures unreleased. Load tests soon trigger HTTP 503 errors even though the database is healthy. What primary security risk does this practice create?
Introduction of race conditions during concurrent database writes
Risk of stack overflow due to unbounded recursion
Exposure to SQL injection attacks on the database
Resource exhaustion through unreleased connections, leading to a denial-of-service condition
Neglecting to close JDBC connections on every execution path causes a connection leak. As more requests arrive, the finite connection pool is exhausted, eventually starving the service of threads or memory and forcing it to reject traffic. This uncontrolled resource consumption leads to a self-inflicted denial-of-service. SQL injection, race conditions, and stack overflows are unrelated to unreleased connections.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a JDBC connection pool?
Open an interactive chat with Bash
How does resource exhaustion cause denial-of-service?
Open an interactive chat with Bash
How can connection leaks during failed REST calls be prevented?
Open an interactive chat with Bash
What is a JDBC connection and why does it need to be closed?
Open an interactive chat with Bash
How does resource exhaustion lead to a denial-of-service (DoS)?
Open an interactive chat with Bash
What best practices exist to prevent JDBC connection leaks?
Open an interactive chat with Bash
ISC2 Certified Secure Software Lifecycle Professional (CSSLP)
Secure Software Implementation
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .