Patent ID: 7921084

Claim:
A method, implemented on a computer, comprising: providing, at a JDBC subsystem which includes a connection pool and prepared statement cache for use by clients in accessing a database, a profiling component which maintains usage information concerning the connection pool and prepared statement cache, including information as to which client is currently using the pool and prepared statement cache and their current usage thereof, and a statistics monitoring component which maintains cumulative statistical information concerning the connection pool and prepared statement cache; upon an event, compiling a diagnostic image about a state of server software, the diagnostic image including information concerning the JDBC subsystem as received from the profiling component and the statistics monitoring component, into a data stream, and starting a timer upon the compilation of the diagnostic image; compressing the data stream; upon a second event, if the timer indicates that the diagnostic image was recently compiled, inhibiting the compilation of a new diagnostic image, and if the timer indicates that the diagnostic image was not recently compiled, compiling a second diagnostic image; and wherein the second event is an indication of a failure, the second event occurring independently from the timer such that only when both the timer indicates that the diagnostic image was not recently compiled and the second event occurs does the compilation of the new diagnostic image occur.