title: Connect to H2 database using IntelliJ database client
body: <p>My Grails app uses a h2 database in dev mode (the default behaviour for Grails apps). The DB connection settings in <code>DataSource.groovy</code> are</p>
  
  <pre><code>dataSource {
      pooled = true
      jmxExport = true
      driverClassName = "org.h2.Driver"
      username = "sa"
      password = ""
      dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
      url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE"
  }
  </code></pre>
  
  <p>I'm trying to setup a connection for this database using IntelliJ IDEA's database client tools. I start off creating the connection like so</p>
  
  <p><img src="https://i.stack.imgur.com/x44oQ.png" alt="enter image description here"></p>
  
  <p>Then in the following dialog, I enter the JDBC URL</p>
  
  <p><img src="https://i.stack.imgur.com/wBdGD.png" alt="enter image description here"></p>
  
  <p>And choose all available databases on the "Schemas &amp; Tables" tab.</p>
  
  <p><img src="https://i.stack.imgur.com/JP4OS.png" alt="enter image description here"></p>
  
  <p>The "Test Connection" button indicates success, but as you can see from the red circle, no tables are found. It seems like I've correctly setup a connection to the h2 server, but not the schema itself.</p>
  
  <p>BTW, I try to setup this connection once the app is running, so I'm sure that the schema/tables do actually exist.</p>