Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

GUI to examine database

 
Barry Burd
Author
Ranch Hand
Posts: 118
5
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
norman richards
Author
Ranch Hand
Posts: 367
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
5
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 367
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
5
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Port 1701 does the trick! Thanks.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic