Browsing embeded database

From OpenKM Documentation
Revision as of 08:54, 26 September 2010 by Christoph.xmt (talk | contribs) (A simply way to browse it)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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/ 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:


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

Okm 005.jpeg

More info at Starting hsqldb manager on JBoss.