19 February 2013

How to get into h2 database file for your play! framework 1.x

Steps I took to get a filesystem H2 database console working where my app is in c:\play\myapp:

  1. Go to localhost:9000/@db
  2. Choose the Generic H2 Server option in the first box
  3. For the url enter jdbc:h2:file:c:/play/myapp/db/h2/play
  4.  Username is sa
  5. Password is blank
  6. Done :)