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, 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