Browsing embeded database

OpenKM comes with FOUR embeded databases that are defined in poll openkm-ds.xml into $JBOSS_HOME/server/default/deploy directory

• OKMActivity ( used for log info )
• OKMAuth ( user for authentication purpose )
• OKMDashboardStats ( used for dashboard info )
• OKMWorkflow ( used to store workflow info )

A simply way to browse it

Check the JAVA_OPTS in bin/run.sh. java.awt.headless has to be false to use the embedded database browser.

An example JAVA_OPTS could be:

 JAVA_OPTS="-Xms256m -Xmx1024m -XX:PermSize=64m -XX:MaxPermSize=128m -Djava.awt.headless=false"

Open the url from server http://localhost:8080/jmx-console/. You'll see there three services defined under JBoss:

database=OKMActivity,service=Hypersonic
database=OKMAuth,service=Hypersonic
database=OKMDashboardStats,service=Hypersonic
database=OKMWorkflow,service=Hypersonic
database=localDB,service=Hypersonic

Select one datasource, then look for void startDatabaseManager() and press the Invoke button. You will see an screen like this:

More info at Starting hsqldb manager on JBoss.