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

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content