How to validate that a connection is 'clean', with no XA resources/ghosts attached before use.
Issue
validate-on-matchchecks 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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
