On 11/11/2010 22:04, Andreas Henningsson wrote:
Embarrassing to ask....
I need help with something very simple. Connecting to my database anq query it.
with that web based database browser. By the way, does anyone know a
good database
tool for mac os x that I can use to connect to a h2 database?
Anyway ...
I have put my database in my home folder. An also the jar file. Then I
do like this.
java -jar h2-1.2.132.jar AppDB.h2.db
The web based sql tool starts. But where is my tables? what am I missing?
/Andreas
Hi Andreas,
You should be able to access the data fine through the web console. It
works very well.
To access the data, do "java -jar h2-1.2.132.jar" from the directory
that contains AppDB.h2.db . When the web console comes up, set Driver
Class to "org.h2.Driver", set JDBC URL to "jdbc:h2:AppDB" and set
username and password to the correct login details (the same as those
which were used when the DB was created, or a specific user if one was
created manually later).
Click connect.
Cheers,
Jesse
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
