Enhancement to Log Stranded Statements, etc.

  • Hi,

    I use this product a lot with great success.  I've had occaision to add two features (I'm using V1.1) which you might be interested in.

    1.  I've enhanced p6spy to log Connections, Statements, PreparedStatements, and CallableStatements which are stranded (not properly closed).  This is a common developer mistake that can tank apps in a DB2 and Oracle environment.

    2.  I've added a timing for establishing connections.

    I'm using V1.1.  I'll gladly share the source of my changes with you, although you would want to rework the code in your own style.  If interested, please contact me via email.  Thanks.

    Derek C. Ashmore