How to access the development database with the Play! framework?

Question

I want to see the tables of my Play! application with the H2 console, but all I see is a list of internal tables of the db engine. How can I view the tables of my application?

Answer 1

Log on to the JDBC URL jdbc:h2:mem:play instead. That is where the development database runs on at least on my Play instance.

Answer 2

Most likely, you are looking a different database. Could you verify the database URL is really jdbc:h2:~/play?

You should also consider upgrading to a more recent version of H2. The version you are using (1.3.149) is a beta version.