Difference between revisions of "Browsing embeded database"
From OpenKM Documentation
(Created page with '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 ( …') |
(→A simply way to browse it) |
||
| (7 intermediate revisions by 2 users 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: | ||
| − | |||
database=OKMActivity,service=Hypersonic | database=OKMActivity,service=Hypersonic | ||
database=OKMAuth,service=Hypersonic | database=OKMAuth,service=Hypersonic | ||
| Line 16: | 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]] | |
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.
