Personal Knowledge Base
Wednesday, March 1, 2017
H2 database server mode
1) start H2 server with tcp parameter
java -cp h2-1.4.191.jar org.h2.tools.Server -tcp -tcpAllowOthers -trace
2) connet to db by following url
jdbc:h2:tcp//localhost/~/test
userName:SA, no password
HSQLDB Server mode
1) user following command to start hsqldb in server mode
bin>runServer.bat -database.0 file.mydb --dbname.0 xdb
xdb is alias of database
2) use following URl and user name to connect
jdbc:hsqldb:hsql://localhost/xdb
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)