JDBC datasource not fault tolerant in JBoss and needs connection validation enabled in EAP 4.x/5.x

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In