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