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/ The HSQL Database manager is available from hsqldb.jar available in:

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.

No comments: