How to use a persistent H2 database in the Play Framework instead of in-memory

database playframework playframework-2.0 h2
Brad picture Brad · Sep 6, 2012 · Viewed 12k times · Source

The H2 database used in the Java Todo List tutorial is the following: 

db.default.driver=org.h2.Driver
db.default.url="jdbc:h2:mem:play"

How do I modify the configuration file to use a persistent database as opposed to an in-memory version. Do I need to setup an entirely separate DB or can I modify the db.default.url property?

I'm using Play! 2.0.3.

Answer

Brad picture Brad · Sep 6, 2012

I found the solution.

To create a file database, modify the following:

From 

db.default.url="jdbc:h2:mem:play"

To

db.default.url="jdbc:h2:file:data/db"

Where data/db is broken down into:

data/ The folder location of the database files relative to your project root.

db The name of your database files.

Related questions

How to set up different databases per environment in Play 2.0?

I'd like my Play app to use different databases for test, local and production (production is Heroku) environments. In application.conf I have: db.default.driver=org.postgresql.Driver %dev.db.default.url="jdbc:postgresql://localhost/foobar" %test.db.default.…

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More