Connect to H2 database using IntelliJ database client

by

Your configuration is for an h2:mem database. Memory Databases have no tables upon connecting to them, and any & all tables are lost when all the connections are closed. Furthermore, a (named) in memory database is unique to the JVM process that opens it. From the H2 documentation:

Sometimes multiple connections to the same in-memory database are required. In this case, the database URL must include a name. Example: jdbc:h2:mem:db1. Accessing the same database using this URL only works within the same virtual machine and class loader environment. (Emphasis added)

This means IDEA will create a unique devDb in its JVM (and classloader) space and your application will create a unique devDb in its JVM (and classloader) space. You can not connect to an in memory database from an external JVM process.

If you want to connect both your application and IntelliJ IDEA (or any other DB tool) to an H2 database at the same time, you will need to either

  1. use an embedded database (that writes to a file) in your application and use Mixed Mode to allow IntelliJ IDEA (and/or other database tools) to connect to it
  2. use a server mode database

See http://www.h2database.com/html/features.html#connection_modes for more information.

More Related Contents:

  1. Grails unable to install plugin
  2. Accessing the raw body of a PUT or POST request
  3. Grails3 file upload maxFileSize limit
  4. How to access Grails configuration in Grails 2.0?
  5. Does Grails 2.3.x Support JDK 8
  6. Why should grails actions be declared as methods instead of closures and what difference does it make?
  7. How to run a local plugin in Grails 2.0?
  8. Overriding grails.views.default.codec=’html’ config back to ‘none’
  9. Eclipse error: indirectly referenced from required .class files?
  10. Java “lambda expressions not supported at this language level”
  11. IntelliJ IDEA 9/10, what folders to check into (or not check into) source control?
  12. How to import build.gradle into IntelliJ
  13. JAVA_HOME should point to a JDK not a JRE
  14. Why is the Android test runner reporting “Empty test suite”?
  15. How to convert a normal java project in intellij into a JavaFx project
  16. Hot swapping in Spring Boot
  17. Maven home (M2_HOME) not being picked up by IntelliJ IDEA
  18. How do I create a runnable JAR in IntelliJ as I would in Eclipse
  19. Error: Gradle: execution failed for task ‘:app:preDexDebug’
  20. Copy entire directory contents to another directory? [duplicate]
  21. How to set JVM arguments in IntelliJ IDEA?
  22. BUG! exception in phase ‘semantic analysis’
  23. Class Not Found: Empty Test Suite in IntelliJ
  24. Change remote repository credentials (authentication) on Intellij IDEA 14
  25. Android Studio 1.2 – Project encoding mismatches by default
  26. How to set gradle home while importing existing project in Android studio
  27. IntelliJ IDEA 13 uses Java 1.5 despite setting to 1.7
  28. First Flutter App error: cannot resolve symbol “Properties”
  29. How to add android.support.v7.widget.GridLayout into intelliJidea?
  30. How to: Install Plugin in Android Studio

Leave a Comment