JDBC datasource not fault tolerant in JBoss and needs connection validation enabled in EAP 4.x/5.x
Issue
- Does the
<validation>tag continuously check for the DB to come back alive and continue without having to restart JBoss? - After performing database maintenance or an outage JBoss does not reconnect.
- How to enable connection validator for datasource connection pool in JBoss.
- We're getting "No operations allowed after connection closed" on our DB connections, how can we make sure the connections are valid before using them?
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 4.x
- 5.x
- Red Hat JBoss Enterprise Portal Platform (EPP)
- 4.3
- 5.x
- Red Hat JBoss SOA Platform (SOA-P)
- 4.3
- 5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
