Wednesday, January 14, 2015

Alternative to SitesExplorer on Mac OS X

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.