Java EE 8 Development with Eclipse - Third Edition

Configuring a datasource

In Spring, you can configure a JDBC datasource either in Java code or in the XML configuration (context) file. Before we see how to configure a datasource, we need to add some dependencies in Maven. In this chapter, we will use Apache's Commons DBCP component for connection pooling (recall that in Chapter 4, Creating JEE Database Applications, we selected the Hikari connection pool). Visit https://commons.apache.org/proper/commons-dbcp/ for details on Apache DBCP. In addition to adding a dependency for Apache DBCP, we need to add dependencies for Spring JDBC and the MySQL JDBC driver. Add the following dependencies to the pom.xml of the project:

<!-- Spring JDBC --> <dependency> <groupId>org.springframework</groupId> ...