Application Server Database Connection Services, Design And Implementation

Content: With the rapid development of electronic business, application server is used more and more widely. Based on the Internet, such all kinds of business applications as WEB and EJB are developed with the help of Application server tool. They usually need accessing one or more kinds of relation database management system. In order to support database access, application server integrates database connection service.The study, design and implement of database connection service is illuminated in detail. The part of theoretic study provides the solid foundation and perfect framework for the part of design and implement, including the architecture of application server, database connection service, transaction service and the communication principle between database connection service and transaction service. The part of design and implement emphasizes on service and connection management module, supporting three kinds of database connection service architecture. First, Connection pool is not supported, neither is distributed transaction. Second, Connection pool is supported, but distributed transaction is not. Third, Both of them are supported. The third architecture is emphasized on, providing with connection pool, prepared statement object pool and distributed transaction function.It is proved that database connection service not only makes applications more portable, but also greatly improves the performance of application server. A good choice is provided for efficient and transparent accessing all kinds of relation database management system. It is very fit for concurrent users access in local or distributed computing environment.