Difference between revisions of "Browsing embeded database"

From OpenKM Documentation
Jump to: navigation, search
(A simply way to browse it)
 
(3 intermediate revisions by one other user not shown)
Line 7: Line 7:
  
 
== A simply way to browse it ==
 
== A simply way to browse it ==
'''Open the url''' from server http://localhost:8080/jmx-console/
+
Check the JAVA_OPTS in bin/run.sh. java.awt.headless has to be false to use the embedded database browser.
  
You'll see there three services defined under JBoss
+
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=OKMActivity,service=Hypersonic
Line 17: Line 21:
 
  database=localDB,service=Hypersonic
 
  database=localDB,service=Hypersonic
  
'''Select one''', it'll appear other web page.
+
Select one datasource, then look for '''void startDatabaseManager()''' and press the '''Invoke''' button. You will see an screen like this:
Find void '''startDatabaseManager()''' and press the button under called Invoke and will appear an screen like this:
+
 
 +
 
 +
[[File:Okm_005.jpeg‎|505px|center]]
  
  
[[File:Okm_005.jpeg‎|505px]]
+
More info at [http://docs.jboss.org/jbpm/v3/userguide/thejbpmdatabase.html#d0e2677 Starting hsqldb manager on JBoss].
  
 
[[Category: Developer Guide]]
 
[[Category: Developer Guide]]

Latest revision as of 07: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.