JDBC Insights for Beginners

Getting Started

Pre-Requisities

• Basic understanding of Java and Database

Technologies

• JDK 1.8 and above
• Maven 3+ - Build Tool
• SQLite - SQLite Database
• H2 - H2 Database used for Connection Pool
• Apache DbUtils - Third Party JDBC Wrapper API
• Apache Log4j - Logging Framework
• Lombok - Automate BoilerPlate Code

Topics

• Introduction to Database and JDBC
• Usage of SQLite and H2 Databases
• SQL CRUD Process – Create Read Update Delete
• Usage of log4j – Logging Framework
• JDBC Connection Pool using HikariCP
• Concepts to JPA with Spring JPA
• Introduction to Database Trigger
• Usage of Google Guava Cache for Static Data

Example(s)

• CRUD Java Example using Non-Connection Pool using SQLite
• Search Countries using Non-Connection Pool using SQLite
• Search Countries using HikariCP Connection Pool using H2
• Search Countries using Google Guava Cache
• Ability to Persist Photo in bytes and read back.

References

• Project Source - https://github.com/newfound-systems and Presentation
• Build Tool Maven - https://maven.apache.org/
• Log4J Tutorials - https://mkyong.com/logging/apache-log4j-2-tutorials/
• SQLite - https://sqlite.org/
• SQLite Tutorials - https://www.tutorialspoint.com/sqlite/index.htm
• H2 - http://www.h2database.com/html/tutorial.html#creating_new_databases
• H2 Home - https://www.h2database.com/html/main.html
• JDBC Wiki - https://en.wikipedia.org/wiki/Java_Database_Connectivity
• Markdown - https://guides.github.com/features/mastering-markdown/

Authors

• NEWFOUND SYSTEMS http://www.newfound-systems.com
• Any Questions buzz us at [email protected]

Tasks

• Finished changes
• Baseline to GitHub
• Published as Public Repository

Finally

• 👍 Thanks for your time and Stay Safe!