Database Connection Technologies from JSP Pages and Java Web Application Servlets

The purpose of the study is to demonstrate the diversity of solutions on the issue of connecting to a database, including a description of the developed connection controller class, as well as various ways to create connection pools on a web server and application servers. The article discusses the practical issues of using JDBC technology when building a Java web application. In the examples, the presentation and business layer of the application are developed using JSP-pages and servlets, the database operates on the MySQL platform. The described methods for creating and configuring a connection pool are shown on the example of the ApacheTomcat web server and the GlassFish application server. The question of optimizing database connections in Java applications remains open, despite the diversity of solutions. The study examines and proposes methods for constructing classes of connectors, various methods for creating pool connections, and describes the results of solving problems arising from the implementation of the described techniques. A detailed classification of ways to connect to the database is given.

Based on SVM Classification of Connection Pools Algorithm

The connection pool technology has become a deal with large amount of data requested a solution that is widely used now. This paper used the SVM classification algorithm for classified all database requests quickly, so the corresponding database request could be assigned to different connection pool distribution. We applied the connection pool to measurement service platform and tested on the accuracy of the SVM classifier and buffer pool hit ratios of the connection pool module. The experimental results show that the connection pools can improve the efficiency of database access obviously.

A Study of Database Connection Pool

Nowadays, object-oriented design is the trend of software design patterns, and the database connection pool is one of the important research topics. The paper firstly describes the basic principle of connection pool under traditional, tomcat and hibernate modes. Based on that, a new connection pool method is proposed, and these four methods are experimentally simulated in java language at last. The comparative analysis has verified that the presented connection pool owns the optimum access time and it can greatly improve the access efficiency of database.

Security Problem Modeling of Database Connection Pool

Connection pool is widely used in 3 tiers Web system based on database. It can improve performance of the Web system, but brings security problem to the system at the same time. The formal model of 3 tiers Web system is proposed, and the root of security problem, absence of subject transmission from Web application to database management system, is found from the model. In addition, several methods to solve the security problem faced by database connection pool in 3 tiers Web system are introduced or proposed.

Research on the Security Audit of Database Connection Pool

After analyzing the security issues database connection pool faced, the database connection pool audit system (DCPAS) is proposed. This system can trace the identity of the end user by binding the user's operation to their executing SQL statements, and make the end user auditing possible. The experiments show that DCPAS could audit the action of end user.

The Application of Database Connection Pool Based on Java in Things Networking

In view of the application of database operation in the things networking, this paper introduces the principle, the working process, the key technology and the realization method of the database connection pool. For the database operation which used JAVA language to formate, we contrasted the accessing time between use connection pool and do not use connection pool. The results show that the appropriately use of the database connection pool technology can improve the real-time performance of the database operation in things networking greatly.