Hey Dan, This was useful. Thanks. Database tools and SQL is not available in community edition. I tried another plugin Database Navigator. Unfortunately that also doen't support h2. Nonetheless, this video was helpful. Sub'd. Waiting for more content.
hi jigar, I am not sure what problem you encounter but in commutiy edition it can be done via start.spring.io/ . In this website generate your jar file and import to your intelliJ. I hope it solves your problem. Best regards
Thank you for this amazing video Dan! For some unclear reason when I try to use a db file and not from memory, the table I created in the data/schema is not visible, also, it didn't require the "sa" username, maybe there's some connection to the issue?
Hello. If I log in from console with default datasource url (jdbc:h2:mem:testdb) using sa and "" as username and password, it works smoothly, but if I try to change the datasource url, the application itself will run nicely but then as I'm trying to connect to the h2 database, it throws a "invalid password or username" error. I tried to fix it by setting the username and password manually with the spring.datasource.username and spring.datasource.password, but after that the application won't even run, stating the same issue with invalid password or username.
just fixed it. might be too late for you but this could help others. if you persist the data in your disk there is no authentication i.e both username and password strings are empty
Thanks! After creating the file jdbc connection and testing it, it says my username or password are incorrect, any ideas? After removing both username and password I am able to connect, but there aren't any tables. Only difference is instead of inserting as shown in the video, I'm inserting using CSVread
Anybody who follows this tutorial and still cannot connect, here is you answer stackoverflow.com/questions/72255338/intellij-embedded-h2-database-tables-do-not-appear
Despite using the community version I am able to run the code and to open the database in the browser. However, the database is not pulling my table. If you have any idea what the reason might be, let me know.
Hello, I got the same problem and looking for a answer I found your comment. Maybe it is too late for an answer and maybe it is not the same reason but I would like to share my solution. Actually it is not the solution it a wording problem for me. In application.properties folder, I needed to write "spring.jpa.hibernate.ddl-auto=none". If you have not, you can check. In my case I did a word mistake and I spent hours to solve this problem :(
@@burakkusku5387 Thanks a lot. :) I don't remember my solution, i had to re-set up my laptop and lost all my files in the process but I got the problem fixed. I did it differently from what I remember but it's never a bad idea to have multiple solutions to a problem.
Thx for the video. Currently I am looking for the exact same setup including the IntelliJ View 'Persistence' in order to be able to directly work with jpa-ql when developing. I do not get it working and I feel somewhat blind on any cause. That is a major use case for me as a devloper: a very efficient way of wrinting queries with JPA.
What are some of your favorite plugins & themes for IntelliJ?
Codota, Lombok, Maven Dependency Helper, "Yet another emoji support" to add emojis for frontend, I'm also enjoying the One Dark Theme plugin
Lombok
Sonarlint
Hey Dan,
This was useful. Thanks.
Database tools and SQL is not available in community edition. I tried another plugin Database Navigator. Unfortunately that also doen't support h2.
Nonetheless, this video was helpful. Sub'd. Waiting for more content.
Ahh bummer, sorry about that. I just assumed they were and that is a bad job on my part. Thanks for letting me know.
hi jigar, I am not sure what problem you encounter but in commutiy edition it can be done via start.spring.io/ . In this website generate your jar file and import to your intelliJ. I hope it solves your problem. Best regards
I got the same problem. It only works with IntelliJ Ultimate Edition. Does anyone know to make it work withou it?
I'm starting with Spring Boot and Databases and looked exactly for this help. Very useful. Thank you!
Great to hear!
Thank you for this amazing video Dan!
For some unclear reason when I try to use a db file and not from memory, the table I created in the data/schema is not visible, also, it didn't require the "sa" username, maybe there's some connection to the issue?
same here
Hello. If I log in from console with default datasource url (jdbc:h2:mem:testdb) using sa and "" as username and password, it works smoothly, but if I try to change the datasource url, the application itself will run nicely but then as I'm trying to connect to the h2 database, it throws a "invalid password or username" error. I tried to fix it by setting the username and password manually with the spring.datasource.username and spring.datasource.password, but after that the application won't even run, stating the same issue with invalid password or username.
spring.datasource.username=sa
spring.datasource.password=
did you fix it
just fixed it. might be too late for you but this could help others. if you persist the data in your disk there is no authentication i.e both username and password strings are empty
@@lourdessanthosh7465 Thanks for the tip. That was it!
Thanks! After creating the file jdbc connection and testing it, it says my username or password are incorrect, any ideas? After removing both username and password I am able to connect, but there aren't any tables. Only difference is instead of inserting as shown in the video, I'm inserting using CSVread
is it possible to use hikari with an in memory database like h2 just to test the pooling?
Anybody who follows this tutorial and still cannot connect, here is you answer stackoverflow.com/questions/72255338/intellij-embedded-h2-database-tables-do-not-appear
Thanks for this helpful video, but the swallowing kills me inside
Thanks Buddy, its very useful
Despite using the community version I am able to run the code and to open the database in the browser. However, the database is not pulling my table. If you have any idea what the reason might be, let me know.
Hello, I got the same problem and looking for a answer I found your comment. Maybe it is too late for an answer and maybe it is not the same reason but I would like to share my solution. Actually it is not the solution it a wording problem for me. In application.properties folder, I needed to write "spring.jpa.hibernate.ddl-auto=none". If you have not, you can check. In my case I did a word mistake and I spent hours to solve this problem :(
@@burakkusku5387 Thanks a lot. :) I don't remember my solution, i had to re-set up my laptop and lost all my files in the process but I got the problem fixed.
I did it differently from what I remember but it's never a bad idea to have multiple solutions to a problem.
@@burakkusku5387 Thanks! That helped!
Can you please help me as well with connecting the H2 database with the community edition of intellij
I have to do a demo at work today. That'll be immensely helpful. Thank you!
gracias por todo
Thanks for the video! when I try use the db file, it doesnt show me the table in the h2 console. It worked when i used it from memory. Any ideas?
Can you use AUTO_SERVER=true for mem variant?
Thanks a lot! I was wondering, why I can't see my tables in IntelliJ, now I have an answer.
Thanks, Dan! Fixed my problem when you mentioned "relative paths".
Glad it helped!
Thank you, i was really struggling with the h2 mem
Thx for the video.
Currently I am looking for the exact same setup including the IntelliJ View 'Persistence' in order to be able to directly work with jpa-ql when developing.
I do not get it working and I feel somewhat blind on any cause. That is a major use case for me as a devloper: a very efficient way of wrinting queries with JPA.
Very nice. Can you explain zonkey test ? Thank you..
You are damn good buddy, this helped me a lot.
Ajudou bastante, estava com dificuldades em conectar com o banco h2, obrigado.
Thanks god, You are not talking in hinglish
Thanks a lot! I didn't know how to get access from IntelliJ!
Super! Exactly what my challenge has been! Thanks!
Thanks for the tutorial
GOAT OF THE DAY
Thanks Dan ! Regards from Brazil
Thank you Dan. Video was really useful
Great video! Thank you!
Really well explained and clear! Thank you Dan!!!
thanks alot
Thank you so much
Brilliant Dan, thank you so much
you are my hero!
I am so grateful for the video, thanks a lot!
You are welcome! Thank you for the kind words