Jack
Jack

Reputation: 16728

What tool can I use to view the changes in an in-memory H2 database?

I switched to using an in-memory H2 database for development. It works great, but I'm not able to see my changes as I make them.

This is their suggested list of tools: http://h2database.com/html/links.html#tools

I tried DB Visualizer and SQL Developer, but I can't find the tables my software creates. Are there any gotcha's that I should be aware of when working with H2, or any suggestions on a nice tool for Linux.

Upvotes: 2

Views: 6563

Answers (2)

Abdennour TOUMI
Abdennour TOUMI

Reputation: 93421

to be independent of the operating system used(Win,Linux(Ubuntu,..),Mac),Execute this command :

java -cp h2*.jar org.h2.tools.Console


It will open the browser : http://localhost:8082


enter image description here

Upvotes: 2

blahdiblah
blahdiblah

Reputation: 34031

I've generally just used their web interface, found at http://localhost:8082 by default.

Their quickstart guide covers making it available on Windows in great detail, but I recommend simply checking http://localhost:8082 as a first step to see if it's already up and running.

Upvotes: 1

Related Questions