Use HSQL Database Manager. For example: Oracle Webcenter Sites Jump Start Kit is installed in user’s home Library directory (~/Library/Oracle/JSK/11.1.1.8.0.app). The HSQL Database manager is available from hsqldb.jar available in:
~/Library/Oracle/JSK/11.1.1.8.0.app/App_Server/apache-tomcat-7.0.42/Sites/lib.
From Sites directory launch
Database Manager using the command:
$java –cp ./hsqldb.jar
org.hsqldb.util.DatabaseManagerSwing
In the Database Manager use
the following connection parameters:
- Type: HSQL Database Engine In-Memory
- Driver: org.hsqldb.jdbcDriver
- URL: jdbc:hsqldb:file:./default/data/hypersonic/csDB
- User: SA
SQL instructions
can be used in order to view and manipulate data from JSK HSQL database.
