Spring Boot H2 Database Console

How to create a Spring Boot application that includes the Java H2 database. H2 database is a great option for development because it's open-source, light-weight and has both an in-memory and file-based implementation.

When we have a Spring Boot application up and running we will build out a small sample application using Spring Data JPA that will add some data to our H2 database. From there we will learn how to configure the H2 Database console in Spring Boot and how to access it.

When you have completed this tutorial you should understand:
✅ What is the Java H2 Database
✅ How to create a Spring Boot Application and include the H2 Database dependency
✅ How to create an entity in Spring Boot
✅ How to create a Command-Line Runner to add data to your H2 database
✅ How to configure the H2 Database & Console in Spring Boot
✅ How to access the Spring Boot H2 Database Console

RESOURCES & LINKS MENTIONED IN THIS VIDEO:

CONNECT WITH ME:

[Laharnaman]

Nice work Dan. Finally! -- a H2 / JPA tutorial that actually works out of the box! Tried 3 or 4 already and there is always something that doesn't quite work. Many thanks!

[amitsaxena]

It made me work better to use multiple applications having different database with new data insert in same h2 console by changing the url it make me work better
Thanks for this video.

[juliochaconvilela]

The video was very useful for me, thanks for sharing. Greetings from Peru.

[generichuman_]

I demand to speak with this h2 council!

[dheerajjodha]

Thank you, I found this really useful!

[jefferybrannon]

Great video. H2 Council? That is a bit distracting. H2 "kon soul" :)

[tasdcxyt]

Thank you very much! It really helped me:)

[OFFICALANIME]

Wonderful video. Was exactly looking for this. thank a lot.

[alexandershaitan]

Cпасибо тебе человек !!! god bless you man

[seyademcileli]

Thank you for this tutorial!

Question, what if we're creating a Maven web-app project in IntelliJ Ultimate? Do we need to add h2 properties in a persistence.xml or do we just go about it like you have in this tutorial? Thanks again!

[selimbulut]

H2 database, How can I make it read-only, writable?

[ensiyehrahbar]

Thank you so much for sharing very good topic which I was looking for. But I don t know why I could not change Datasource name, for me was not work properly :(

[christopherreffell]

Dan i am passionately in love with your teaching. i am one of your student from Udemy, you tutor me spring boot2. i really want to master spring boot with Angular, and do need your help to achieve that.
can you please help with creating and manipulating with tables and queries and working with relationships

[MikheilZhghenti]

So, is it not possible to connect H2 console from IntelliJ DataBase section ?

[dipronildey]

Hello, how to do it if I am only using a Spring mvc now Spring boot? how to connect to H2 database and add the sql scripts?

[BekTesfa]

What about connecting to an H2 Database using the Intellij IDE itself as opposed to using a localhost console? Can you view the tables through both intellij Database interface as wells using localhost?

[thanosfisherman]

Hi, I was wondering can I use IntelliJ's database tool to connect to H2 without having to enter the console? I actually tried it and the connection was successful but I couldn't see any of the tables/records

[billbill]

Thanks for your video!

In my case, the default JDBC URL is "jdbc:h2:~/test"
after click Connect, there is an error to inform me that test database does NOT exist.

Do you possibly know the cause?

[kitsukuw]

I think you can understand that WE CAN"T read what is on your screen, do you?