Difference between revisions of "Browsing embeded database"

From OpenKM Documentation
Jump to: navigation, search
(A simply way to browse it)
 
(One intermediate revision by one other user not shown)
Line 7: Line 7:
  
 
== A simply way to browse it ==
 
== 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:
 
Open the url from server http://localhost:8080/jmx-console/. You'll see there three services defined under JBoss:
  
Line 18: Line 24:
  
  
<center>[[File:Okm_005.jpeg‎|505px]]</center>
+
[[File:Okm_005.jpeg‎|505px|center]]
  
  

Latest revision as of 08:54, 26 September 2010

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:


Okm 005.jpeg


More info at Starting hsqldb manager on JBoss.