An introduction to JDBC, JNDI and Spring JDBC with Tomcat
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
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
Description
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
Who this course is for:
- Java Developers who have to write code to access a relational database
- Java Developers who want to use Spring JDBC for streamlining database access to a relational database
Instructor
- 3.9 Instructor Rating
- 65 Reviews
- 7,136 Students
- 3 Courses
Accomplished in the full life cycle of software design from requirements definition, prototyping, proof of concept through to implementation, testing, maintenance and system enhancements.
Technical Expertise
Languages:
Java 8, SQL, XML, JavaScript
Frameworks:
Apache Camel, Spring Boot , JDBC, Mockito, Spring Security , Spring Data - JPA, Junit, Redis, RabbitMQ, ActiveMQ
API's:
RAML, REST/Json, Eclipse SWT, JavaBeans, JSP, Servlets, EJB 2.1, Collections, JTA, JDBC, Eclipse Platform SDK
Concepts:
OOA/OOD (UML, Design Patterns, Re-factoring), SOA, Micro Services, Unit Testing, Mock Objects, RUP, Agile, Scrum, TDD
App. Servers:
Jboss AS, IBM Webshpere, Equinox OSGI, BEA Weblogic, Tomcat, OpenCMS
Release Tools Docker, Maven, Bamboo, Subversion, Jira, Ant, CVS, Git, Rational Suite
IDE’s :
IntelliJ IDEA, Eclipse, Spring Tool Suite
Databases Mongo DB, Oracle, MS SQL Server, MySQL
OS:
Windows, Linux