View post: Lurking at Hypersonic data
Navigation
Recent posts from all feeds
- hSenid - officially certified JBCP partner
- jBPM 3 seam/jsf/richfaces based console
- Help push the open sourcing of a jBPM Migration Tool
- JBUG Munich meets Pete Muir with JSR-299 - Contexts and Dependency Injection for Java EE (06.07.09 at 19:00 PM)
- Javarsovia, static analysis and annotations
- Drools Job requested - Buenos Aires Argentina
- Seam and Web Beans downloads temporarily relocated
- Introducing a new smart forms tool: Drools Advisor
- JBoss Cloud introduction video
- Using rich:colorPicker in RichFaces
- « Back to feed: JBoss Portal
Lurking at Hypersonic data
There are times when you want to look at your database data during development.It is also very common to keep using Hypersonic as a database during that same phase.
But do you know how to look at your JBoss Portal data ? Here is an entry-level explanation on how to do it. I got the idea of this blog entry by reading a question on a forum and hope it could help.
JBoss AS includes the "HSQL Database Manager" a GUI to execute SQL request on a HSQL server. To access it, you will need to go through the JMX console and locate the startDatabaseManager() operation on the jboss:database=localDB,service=Hypersonic MBean.
Clicking on "Invoke" should open up a new application that looks like this:
You see the content of the default datasource of JBoss AS. Now to see the default datasource of JBoss Portal click on File>Connect... You will see the following screen (after enlarging the window horizontally):
In the URL just change the final part: /data/hypersonic/localDB to /data/portal/hypersonic/database then click Ok.Voila, you can now browse the default JBoss Portal database and do SQL queries on it:
Note: If you wish to restart from fresh with default data, you simply need to delete the files from: server/default/data/portal and restart JBoss AS.
Post to DZone
Post to del.icio.us
Digg this!
Stumble It!