Access mem or fs database tables using H2 console

playframework h2
Sedir Morais picture Sedir Morais · Jun 7, 2011 · Viewed 8.5k times · Source

I'm trying to access my application's tables in Play! Framework, but I can't find it using the console. For instance, I have two entity models: Address and Campus.

I can create objects and save normally, but I would like to see the changes in fs or mem DB, but the H2 console doesn't show the tables Address and Campus. I'm using the default settings to log in localhost:9000/@db.

What am I doing wrong?

Thanks in advance.

Answer

Juan Ramón Paniagua picture Juan Ramón Paniagua · Jun 9, 2011

The correct URL for the inmemory database is:

jdbc:h2:mem:name-of-your-play-db

Related questions

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

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 …

Read More
Accessing play project database with h2-browser

I am having some trouble accessing the mem database via the h2-browser on a Play framework project. With the configuration below, that I think is the correct one (apparently not!) I am getting a h2-browser, but with no …

Read More
Error: Argument is not a function, got undefined

Using AngularJS with Scala Play, I'm getting this error. Error: Argument 'MainCtrl' is not a function, got undefined I'm trying to create a table consisting of the days of the week. Please take a look at my code. I had …

Read More