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

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).