Does JBoss support Multi DataSource functionality?

Solution In Progress - Updated -

Issue

Need to create a connection pool with the following functionality:

  • Use round robin against a set of endpoints to fulfill getConnection() requests from the pool
  • Support for Oracle, DB2, MySql, Sql Server, Oracle RAC (individual nodes as well as RAC clusters) as endpoints
  • Permit dynamic addition and removal of endpoints without redeployment of the pool or apps which depend on it
  • If failure is detected in one of the endpoints, automatically fail-over to another endpoint
    • Support configurability of the number of failures before flush of the endpoint's connections or fail-over to another endpoint occurs
  • Automatically "failback" on recovery of a failed endpoint

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP) 6

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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.