wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes GUI to examine database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "GUI to examine database" Watch "GUI to examine database" New topic
Author

GUI to examine database

Barry Burd
Author
Ranch Hand

Joined: Jun 18, 2003
Posts: 118
    
    5

About a month ago I was fiddling around with an example Hypersonic database (from the JBoss tutorials and examples, I think) and I used a GUI to see a tree of the structures in the database. Coming back to the problem a month later, I can't remember what the GUI was, where I found it, whether it was part of JBoss or not -- nothing. I've searched my hard drive for programs that I may have used a month ago, but I can't find a single one. This is driving me crazy. Can anyone point me to a simple GUI tool to examine (and perhaps modify) a simple example Hypersonic database? Thanks.


Java For Dummies, 6th Edition, Java Programming for Android Developers For Dummies
norman richards
Author
Ranch Hand

Joined: Jul 21, 2003
Posts: 367
Look for DatabaseManagerSwing in the hypersonic jar. On 3.2, try this:
java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

You might have to hunt for the right name if you are using an older release...
Barry Burd
Author
Ranch Hand

Joined: Jun 18, 2003
Posts: 118
    
    5

Thank you. That found the database manager for me. But now I get a connection refused message when I try to connect to jdbc:HypersonicSQL:hsql://localhost:1476. If I recall, there was a really easy way to connect. Maybe it was from the jmx-console???
norman richards
Author
Ranch Hand

Joined: Jul 21, 2003
Posts: 367
Originally posted by Barry Burd:
Thank you. That found the database manager for me. But now I get a connection refused message when I try to connect to jdbc:HypersonicSQL:hsql://localhost:1476. If I recall, there was a really easy way to connect. Maybe it was from the jmx-console???

I'm not an expert my any means. You can certainly check the jmx console to make sure you have the right port. You can also check your datasource definition as it should have the complete URL. JBoss 3.2 appears to use port 1701 as the default.
Barry Burd
Author
Ranch Hand

Joined: Jun 18, 2003
Posts: 118
    
    5

Port 1701 does the trick! Thanks.
 
Don't get me started about those stupid light bulbs.
 
subject: GUI to examine database
 
Similar Threads
Configuring Multiple Datasources w/ Jboss 3.2.x
JMSException when starting JBoss...
how to configure postgresqk datasource in jboss
Hypersonic database
JBoss Embedded DB vs MySQL