1. A system comprising: a computer including a processor, memory, and application server operating thereon, wherein the application server enables access between one or more client applications and a database; a JDBC subsystem associated with the application server, wherein the JDBC subsystem includes a connection pool which includes a plurality of connections for use by the client applications in communicating requests to the database, a prepared statement cache which includes a plurality of previously parsed requests that can be reused by the client applications and communicated to the database, a profiling component which maintains profile information concerning the connection pool and the prepared statement cache, wherein the profile information includes a connection usage profile indicating which particular client applications are currently using a connection or a prepared statement with the database, and a statistics monitoring component which maintains cumulative or averaged information concerning usage of the connection pool and the prepared statement cache over all of the client applications; and wherein the system enables a diagnostic image to be created which includes the profile information and the cumulative or averaged information for applications that are being monitored by the JDBC subsystem.
1. A system comprising: a computer including a processor, memory, and application server operating thereon, wherein the application server enables access between one or more client applications and a database; a JDBC subsystem associated with the application server, wherein the JDBC subsystem includes a connection pool which includes a plurality of connections for use by the client applications in communicating requests to the database, a prepared statement cache which includes a plurality of previously parsed requests that can be reused by the client applications and communicated to the database, a profiling component which maintains profile information concerning the connection pool and the prepared statement cache, wherein the profile information includes a connection usage profile indicating which particular client applications are currently using a connection or a prepared statement with the database, and a statistics monitoring component which maintains cumulative or averaged information concerning usage of the connection pool and the prepared statement cache over all of the client applications; and wherein the system enables a diagnostic image to be created which includes the profile information and the cumulative or averaged information for applications that are being monitored by the JDBC subsystem. 2. The system of claim 1 , wherein the connection usage profile indicates when a pool connection was reserved by a client.