Creating database connection pooling

We have created recipes that give us tips and tricks on how to construct and manage the ApplicationContext containers with injected beans, implement and design HTTP request transactions through different types of @Controllers, manage types of scoped-beans, implement views for request dispatch and redirection, and apply the concept of Inverse of Control and Dependency Injection principles. Now, it is time to introduce the integration of the MVC application to some database vendors such as MySQL 5.7. Our main goal is to define, identify, and create the necessary database connection pooling for a Spring MVC project.

Getting started

Create a new Eclipse web project, ch03-jdbc, and configure its pom.xml to make the project web.xml-less. Add the previous Maven dependencies and also implement the same SpringWebInitializer and root context SpringDispatcherConfig for the initialization of our ServletContext. Moreover, set up the same SpringContextConfig for the...