Access mem or fs database tables using H2 console

Question

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.

I don't know the play framework so far... what is your database URL (if there is a database URL in this framework)? — Thomas Mueller, Jun 07 '11 at 14:14
Thanks for this, this is a H2 Gui for PlayFramework, saved me a lot of work looking for a GUI! — David d C e Freitas, Sep 12 '11 at 11:59

score 18 · Accepted Answer · edited Jan 25 '13 at 11:09

18

The correct URL for the inmemory database is:

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

edited Jan 25 '13 at 11:09

biesior

55,576
10
125
182

answered Jun 09 '11 at 15:46

Juan Ramón Paniagua

196
2

the url is logged in the logging information and you can grab it from there. – Dean Hiller Jan 09 '14 at 03:02

score 10 · Answer 2 · answered Jul 01 '11 at 00:46

10

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

Go to localhost:9000/@db
Choose the Generic H2 Server option in the first box
For the url enter jdbc:h2:file:c:/play/myapp/db/h2/play
Username is sa password is blank

answered Jul 01 '11 at 00:46

Peter

111
3

Yes, don't do what I did and add the .h2 extension to the play filename in step 3! – David d C e Freitas Sep 12 '11 at 12:15

score 0 · Answer 3 · answered Jun 08 '11 at 04:41

0

Most likely the problem is the database URL, so your application and the H2 Console are using different databases. I suggest to use a database URL of the form jdbc:h2:~/data/test or (maybe even better) using an absolute path of the form jdbc:h2:/data/test, or when using Windows even with drive letter: jdbc:h2:c:/data/test. See the documentation about where the database files are stored.

answered Jun 08 '11 at 04:41

Thomas Mueller

48,905
14
116
132

is that for just the filesystem method? If I am going to do filesystem, I mine as well use postgres....BUT I would love to connect to the in-memory one just cause it's so fast(no disk i/o). – Dean Hiller Feb 12 '12 at 16:58
never mind, didn't know localhost:9000/@db was a url you could use that actually works!!!! and just hit connect button. of course, I got an internal error as I had H2 console running....can't do that for some reason. – Dean Hiller Feb 12 '12 at 17:04
I didn't fully understand what your wrote... but keep in mind that when using `jdbc:h2:tcp://localhost:9000/@db` it is relative to the current working directory of the server. An absolute directory would be `jdbc:h2:tcp://localhost:9000//data/test` (two slashes after :9000). – Thomas Mueller Feb 13 '12 at 11:47

score 0 · Answer 4 · answered Sep 06 '22 at 06:57

My five cents. In my case (Unix OS) I just managed to make it work using ~/ in my persistence.xml:

<property name="javax.persistence.jdbc.url" value="jdbc:h2:~/data/testxdb" />

In this way the Database was created in: /Users/lm2a/data/testxdb.mv.db and starting the console with

java -jar h2-2.1.214.jar

Finally I could see my Tables.

Access mem or fs database tables using H2 console

4 Answers4

Linked