An introduction to JDBC, JNDI and Spring JDBC with Tomcat

Spring JDBC Support

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

What you’ll learn

  • What is JDBC – Java Database Connectivity.
  • What is the difference between regular Java JDBC and Spring JDBC.
  • What is a JDBC Connection and an overview of the different types.
  • How to set up a JDBC Datasource Connection.
  • How to use the Spring JDBC Template to access a relational database.
  • Understand JNDI and defining a DB Connection.
  • Use Spring Boot to put together an Embedded Tomcat JDBC CRUD Application.

Course Content

  • Introduction –> 3 lectures • 8min.
  • Our JDBC Development Environment –> 12 lectures • 45min.
  • Connecting to the Database –> 6 lectures • 1hr 2min.
  • Comparing traditional JDBC with Spring JDBC –> 6 lectures • 1hr 35min.
  • Closing Section –> 1 lecture • 1min.

Auto Draft

Requirements

  • Be familiar with Java Software Development.
  • Be familiar with modern Java IDE’s such as IntelliJ.
  • Be familiar with the concept of a Relational Database.
  • A basic understanding of the Maven build tool.
  • A basic understanding of Git source control and how to use Github.

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

 

 

Get Tutorial