Default username/password for lift_proto.db

[Uros Nedic]

Does anyone know what is the default username/password combination for default H2

lift_proto.db?

I want to access it by some shell so I can study design of tables a little bit deeply, but

still doesn't want to install MySQL and configure Lift to work with it.

Thanks,

Uros

[Stefan Bradl]

There should be no username or password. I use DBVisualizer to access the db and it works without credentials.

2012/2/13 Uros Nedic <uros....@gmail.com>

--
Lift, the simply functional web framework: http://liftweb.net
Code: http://github.com/lift
Discussion: http://groups.google.com/group/liftweb
Stuck? Help us help you: https://www.assembla.com/wiki/show/liftweb/Posting_example_code

[Jack Park]

The H2 jar file has this class org.h2.tools.Console which, when
booted, pops open a browser that lets you log into the database and
roam about. There is a mild ambiguity with H2 related to the file
name; H2 appends "h2.db" onto the database name, so using the entire
file name given through default by Lift will not let you in.
The view in a browser gives you full SQL access to your database. You
cannot run that while H2 is locked by your program.

Jack

[Diego Medina]

I have a shell script at the root of my Lift project which is:

cat startH2WebConsole.sh
java -cp /home/wizard/.ivy2/cache/com.h2database/h2/jars/h2-1.3.149.jar
org.h2.tools.Server

after I run it, it will start H2 and open the browser to the web interface.
there I have this url connection, which allows me to then start lift
and both can access the database at the same time

jdbc:h2:test_lift_proto.db;AUTO_SERVER=TRUE

Regards,

Diego

--
Diego Medina
Lift/Scala Developer
di...@fmpwizard.com
http://www.fmpwizard.com

[Sofoklis Papasofokli]

Thank you Diego!

Sofoklis

[Uros Nedic]

Thank you for all quick answers! I was off couple days due to State holiday (maybe you have

seen than Google changed a logo on Wednesday because o it!) so I did not reply.

Regards,

Uros