[jboss-jira] [JBoss JIRA] (WFLY-4890) IronJacamar: pool gracefull flush

IronJacamar: pool gracefull flush --------------------------------- Key: WFLY-4890 URL: https://issues.jboss.org/browse/WFLY-4890 Project: WildFly Issue Type: Feature Request Components: JCA Reporter: Bartosz Baranowski Assignee: Jesper Pedersen Attachments: jboss_eap_6.4.1_flush_pool_gracefully.tar.gz This RFE comes from EAP BZ: Sample implemenation of flush-all-connection-gracefully-in-pool Description of problem: A new operation for flushing all connections in pool GRACEFULLY is needed. It was available in JBoss EAP 5 and is missing in EAP 6. Currently JBoss EAP 6 provides two options to flush pools: 1) flush-idle-connection-in-pool Closes connections not used by application (in pool) 2) flush-all-connection-in-pool Closes all connections in pool. This operations causes exceptions on connections that are in use by application. A third operation is needed to flush all connections in pool without immediate kill of in-use connections. It should operate as follows: 1) close idle connections (just as flush-idle-connection-in-pool) 2) mark all in-use connections for need of destroying when returned to pool 3) immediately on return of connection to by application to pool close the connection This operation is needed to support load-balancing of connections in clusters for external providers. Examples: 1) JMS connections even load-balacing of connections. After JMS server restart, connections need to be reopened to evenly spread connections among servers. 2) Oracle RAC service migration. After the service is migrated between RAC nodes, DB connections to old node can linger for very long time (many days) to old node. 3) operation teams need to refresh all connections sometimes (external server maintanance) Version-Release number of selected component (if applicable): JBoss EAP 6.x How reproducible: always Steps to Reproduce: not possible, functionallity is missing Expected results: new operation available on JMS and DB pools Additional info: a sample implementation provided in attachment as patches to 6.4.1 (ironjacamar and jboss-as-connector). The new operation is named "flush-all-connection-gracefully-in-pool" and is available for JMS and DB pools. It doesn't modify any other places like web console, etc.