An introduction to JDBC, JNDI and Spring JDBC with Tomcat

Data Access with Spring JDBC Support using JNDI in an embedded Tomcat Server .

Course Modules :

• Course Introduction - JDBC History & Sample User Story

• Our Spring JDBC Development Environment

• Connecting to the Database

• DAO with Traditional JDBC vs Spring JDBC

• Full CRUD with Spring JDBC Template example

Why learn Spring JDBC ?

• JDBC use is widespread in large companies worldwide

• Actively maintained for 20+ years and counting

• Spring JDBC gives you a “quick win” when dealing with legacy JDBC code

Spring JDBC - Sample User Story

• As an expatriate living abroad I want access to an online database of all charities (non-profits) that operate in my “home country”.

  • I want to be able to find Charities by their Tax Id

  • I want to be able to search by Charity Category such as Environment or Education

  • I want to be able to search by Charity Program Types

Connecting to the MariaDB with JDBC

Establishing a Connection

• Using the DriverManager Class

• Specify the database Connection URLs

Connecting to the MariaDB with Spring:

Define Spring DataSource Bean to get a DB Connection

• Specify the database properties in application.xml

• Using the MariaDB DataSource Bean Class

Connecting to the MariaDB :

Using JNDI DataSource Objects to Get a Connection

• Registering DataSource Object with Naming Service That Uses JNDI API

• Creating Instance of DataSource Class and Setting its Properties

• Using Deployed DataSource Object

Connecting to the MariaDB :

Using JNDI to Get a JDBC Connection in Embedded Tomcat

• Java Main Method to launch Embedded Tomcat

• Registering DataSource Object with JNDI API

• Using the registered JNDI DataSource Object

• Running the JAR with Maven Plugin

Connecting to the MariaDB :

Using Spring App Context to Get a JDBC Connection Tomcat

• Java Main Method to launch Embedded Tomcat

• Defining the DataSource in Spring application.xml

• Adding a context listener to web.xml

• Retrieve the Spring Data Source bean in the Servlet

Connecting to the MariaDB :

Using Spring Annotation Config in Embedded Tomcat

• Java Main Method to launch Embedded Tomcat

• Defining the DataSource in Spring Config Class

• Retrieve the Spring DataSource bean in the Servlet