title: Introspect in-memory H2 Database
body: <p>My Play app uses H2 in-memory database when it runs in dev or test mode. I want to access this database when the app runs in dev mode. So I have the following options</p>
  
  <p>1) Run the database in Embedded/Mixed mode. And make the play framework expose the database to other processes.</p>
  
  <p>2) Run in H2 database in server mode (least preferred). But in this the framework should start the database server deamon process (not manually).</p>
  
  <p>My current application.conf file looks like this.</p>
  
  <pre><code>db.default.driver=org.h2.Driver
  db.default.url="jdbc:h2:mem:dev;MODE=MYSQL;DB_CLOSE_DELAY=-1;"
  db.default.jndiName=dev
  </code></pre>