How to validate that a connection is 'clean', with no XA resources/ghosts attached before use.

Solution Verified - Updated -

Issue

  • validate-on-match checks the validity of the physical connection each time one is requested from the connection pool.
  • need to validate that the connection is 'clean', meaning there are no open transactions, no locks, no held buffers, no cursors, no temporary objects...(Much like if a ‘exec sp_reset_connection’ (oracle specific) is called).

Environment

  • JBoss Enterprise Application Platform

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.