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, tools, and much more.