Patent ID: 7761575

Claim:
A method for providing prepared statement processing within an application server environment, said method comprising: maintaining a connection pool within an application server having an application deployed thereon, said connection pool containing a plurality of connections to a database; generating a prepared statement for a requesting entity, said prepared statement used to access the database; storing the prepared statement into a prepared statement cache located on said application server, wherein the prepared statement cache is maintained within physical storage memory of a computing device; dynamically configuring a number of prepared statements in the prepared statement cache on the application server by the application that includes selecting an algorithm from a predefined list of algorithms by the application, wherein the predefined list of algorithms controls behavior of the prepared statement cache on the application server; receiving at least one request from one or more other requesting entities; and providing access to the prepared statement in the prepared statement cache for the one or more other requesting entities without re-generating the prepared statement a second time.