Patent Document ID: 7784033
Application ID: 11339043

Base Claim:
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.

---

Claim 7:
7. The system of claim 1 , wherein the profile information includes a statement executed profile indicating which client executed the cached statements.