How Spring JDBC Auto configuration works internally ?🤔 Spring Boot Foundation tutorial | MySQL

Ever thought ? how spring boot connects to database ? How Spring JDBC Auto configuration works internally ? How Spring auto configures the jdbc template and datasource ? This is one of the import concept which will build your Spring Boot Foundation. In this tutorial, We will be learning this topic with a practical approach which will prepare us for the spring boot Interview as well.

To execute any sql statements over a database , first we need a connection object. The Datasource component takes connection creation responsibility which is later used by JdbcTemplate under the hood to connect to any database like MySQL before executing any SQL queries.

If the DataSource and JdbcTemplate object creation has not done by the Developer , Spring boot does it by using its autoconfiguraiton feature. The components like DataSourceAutoConfiguration and JdbcTemplateAutoConfiguration does this work under the hood.

In this video we have used different classes to create connection object which will be used by the framework under the hood. We have used DriverManager Datasource , Hikari connection pool, C3p0 connection pool , DBCP connection pooling example as well.

A connection pool helps in creating a number of connections during the server bootstrap itself which is used by the framework before invoking any sql queries over the database. This helps in performance optimisation. Using the connection pool, a same connection can be reused numbers of time and helps in reducing connection creation time for each db operation. Hikari is used as a default Connection Pool in spring boot.

Let’s learn how spring boot configures all these internally through autoconfiguration, if not set by the developer.

Timestamp
------------------

00:00:00 - A Question on Spring Boot Auto configuration
00:03:29 - Spring Boot and JDBC API Integration
00:18:26 - What is a Datasource ?
00:23:30 - JdbcTemplate configuration
00:28:33 - DriverManagerDatasource and it’s drawback
00:37:53 - What is a Connection Pool ?
00:45:56 - Spring Boot + Connection Pool (c3p0) implementation
00:53:20 - How Spring Boot JDBC Autoconfiguration works internally?
01:04:36 - DataSourceAutoConfiguration and
JDBCTemplateAutoConfiguration

#springboot #springboottutorial
#springbootinterviewquestions

For more free/paid courses visit

LINKS AND FREE LEARNING RESOURCES
========
Watch my new mock interview series for java developers

Watch my new Hello spring boot series

Watch Spring boot Hot topics

Java Interview / Question and Answer series

Explain spring Bean Lifecycle

spring core

spring mvc

spring mvc intermediate

Spring JDBC

spring live project

SPRING SECURITY COURSE[NEW]

For more courses visit

Any time you are getting stuck with issues, Feel free to ask for support.

you can ping me on my Facebook page

Make sure to join my private Facebook page (Ask me here)
“SeleniumExpress - Support"

you can ask for support in my website forum

Subscribe to my youtube channel

Follow me on Insta

[SanjayKumar-byoc]

JDBC Auto configuration- I have been haunted by this magic- Thanks for pulling the blanket away!

[fullnaoufal]

I hope to see videos on Spring Data JDBC and the difference with Spring Data JPA :)

[yatendra__singh]

Thank you so much for the exceptional knowledge you have....we are so grateful to you 🙏🙏

[LeoLeo-nxgi]

Truly amazing and in-depth explanations, thanks a ton!!

[usaamaizm]

Please create series on hibernate and core JDBC, servelts too. Thanks ❤

[vndprasadgrandhi]

Hi Bro, Expecting from you latest concepts.plz do waiting for that

[ajitsinghbisht]

Thanks bro… can you create similar content on Distributed log tracing ?

[debanandamahata]

Please provide a video for connection pool hikari connection

[sumanthkumar]

When will you start core Java, jdbc servlet jsp classes

[pritamhippargekar]

Incase thread pool, when thread complete it work, then it will go to dead state, then how it will go back to thread pool. What they have implemented under the hood.

[shaiktappalameennawaz]

Sir when are you going to begin live courses

[ngbean]

Abhliash do you have any kubernetes course

[karunamoorthyramakrishnan]

i am in the exact doubt found this video