Wednesday, October 19, 2011

How to connect HSql DB

How to connect HSql DB:
1), java -cp hsqldb.jar org.hsqldb.util.SqlTool --rcFile r.rc adrive
2), java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

// in the file r.rc ,
urlid adrive
url jdbc:hsqldb:file:C:\Program Files\Common Files\Adobe\CS5ServiceManager\plugins\org.hsqldb_1.8.0.8\update\database\adrive-db;
username sa
password