Design guidelines for concurrent DB connection in SOA
Quick overview of SOA A service-oriented architecture (SOA) is an architectural pattern in computer software design in which application components provide services to other components via a communications protocol, typically over a network. Service-orientation is a way of thinking in terms of services and service-based development and the outcomes of services. The Problem In the current technology world, SOA is becoming more and more common and issues related to concurrency is inevitable if the system design is not proper. With increasing concurrent user requests, the system should be capable of establishing multiple database connections without any deadlock or race condition. Solution/The Design guidelines Some design guidelines I recommend and follow while architecting a system that should be able to establish simultaneous database connections. 1. Don't make your connection static/shared. Static is evil, if not handled cautiously. If the co...