• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

GUI to examine database

 
Author
Posts: 160
11
Android Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Author
Posts: 367
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 160
11
Android Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 367
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 160
11
Android Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Port 1701 does the trick! Thanks.
 
reply
    Bookmark Topic Watch Topic
  • New Topic