H2 Database Spring Boot - How to connect and configure an in-memory H2 database in Spring Boot

In this tutorial, you will learn everything you need to know to connect and configure an in-memory H2 database in Spring Boot. I will also walk you through what you need to look out for if you are using Spring Security in your application.

🔗Resources & Links mentioned in this video:

👋🏻Connect with me:

[zelalemgizachew]

Sacrified some mins to see this video and saved a lot of debugging hours. Thanks for the content.

[maxjustmax]

I have no idea why do you have only 17K subs ... are people blind! I'm glad I found your channel.

[sharine]

I haven't even finished watching it and I can already say: Beautiful video! I've seen others (channels) very good ones, but this one is sensational. It explains exactly what is happening and why. This is giving me unprecedented autonomy, which I would take a good amount of practice and reading time to achieve. Thank you!🤩

[MUSLIMWORLD]

Amazing video❤ was struggling for two days then found this master piece.

[Burborted]

God... I haven't seen anything better, sir. Thank you for sharing your expertise.

[fabricio.entringer]

No doubts! The greatest video about this topic. Simple and straight to the point. 🙂 Congratulations and thanks for sharing it.

[debashishbhattacharjee]

Thanks for sharing such crisps videos.

[berkcr]

oh man, thank you im intern and im studying for this on 4 days. finally i do that thanks to you

[abhishekomprakash]

Thank you for this video. So much valuable information packed in 1 video. Concisely presented. 💯

[caginbektas]

I must say thank you for all your effort Dan. This is a very clear and effective video

[cyper]

Wow, this clears my doubts why you configure the data source that way in your previous tutorials. ❤

[magicianam]

Good work, i'm new to spring & this is better than paid courses.

[andreaang]

Thanks, this was really clear and helpful for an exercise im doing :)

[Alexander-vov]

Thanks for the video, it's a really helpful tutorial

[PrashantRanjan]

Hey Dan,
Thanks for your really helpful videos. It would be really nice if you make a video on how to configure databases like Oracle, MySQL or MongoDB etc any one will work.
Thanks

[securethebag]

is it possible to use hikari with an in memory database like h2 just to test the pooling?

[hassanmohamed-izun]

how does spring repository know about the presence of H2 table

[ameensalem]

Hi, thank you for this tutorial!!
i tried to follow when i do new Book(null, "str") i have error that id connot be null
if i pass an id i have this error : Caused by: After saving the identifier must not be null

[alexandern]

Hi Dan,
As I can see in SB configs EmbeddedDatabase implements shutdown method (which sends SHUTDOWN command to the DB) and SB registres that as destroy method when no Hikari is used.
But if we use Hikari+H2 Hikari knows nothing about whether it is an Embedded datasource or not.
If we use memory-based H2 I suppose it is not a problem.
But what about file-based H2?
What do you think is it safe to use file-based H2 with Hikari? Will it close the file properly?

[kacpersyrnik]

Why this h2 console configuraton is not working with mvcMatchers?

MvcMatcher as I understand is better version of antMatcher because it matches not only for example /demo but also /demo/ and /demo.html

In My project
mvcMatchers("/h2-console/**) is not working but if i have the antMatchers("/h2-console/**) as you, everything is fine, but why?