[OFBIZ-4864] Mechanism to publish information about connection pools

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Trunk
• Component/s: framework
• Assignee: Jacopo Cappellato
• Reporter: Jacopo Cappellato
• Created: 08/May/12 12:13
• Updated: 14/May/12 14:46
• Resolved: 14/May/12 14:46

Description

Please review the attached patch that I would like to commit to trunk:

• enabled by default the DebugManagedDataSource wrapper around ManagedDataSource
• enhanced the DebugManagedDataSource wrapper to:
  • print log messages only at verbose level (instead of always)
  • if possible print additional information about the connection status
  • added new method that returns information about the connection pool settings/status
• added new static method to DBCPConnectionFactory to return information about the pools
• new screen in the webtools where information about each pool/helper is shown (see screenshot)

What do you think? The code is safe and it will not have any impact on performance (unless you enable verbose logging on DebugManagedDataSource). The information provided by the screen can be very useful to analyze the status of the pools.