Improving Connection Pooling Persistence Systems

Server-sided applications often use a persistence system for storing and managing their data in a database. Such a system has become complex and includes but is not limited to a database system, drivers, connection pools, query languages, the mapping between application logic and a database data model and it involves the optimization of resources. One important resource is the connection from applications to the database system since acquiring a connection is a very expensive operation. This paper introduces monitoring facilities for the use or misuse of connections in a persistence system. In particular, it explains how the monitoring can take place in order to configure connection pooling for optimal performance. The implemented solution uses conventional programming methods as well as an aspect-oriented approach. The described facilities are integrated into the development of an enterprise-scale system implementing a communications middleware.