Difference between revisions of "Browsing embeded database"
From OpenKM Documentation
(→A simply way to browse it) |
|||
(2 intermediate revisions 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. | |
− | 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 datasource, then look for '''void startDatabaseManager()''' and press the '''Invoke''' button. You will see an screen like this: | |
− | + | ||
+ | |||
+ | [[File:Okm_005.jpeg|505px|center]] | ||
− | + | 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:
More info at Starting hsqldb manager on JBoss.