• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 872
  • Last Modified:

hsqldb viewer

Hi;

I have a hsqldb database and I want to learn how to view the sql content in hsqldb. Can you give a hand?

Regards..
0
jazzIIIlove
Asked:
jazzIIIlove
  • 5
  • 5
  • 5
  • +1
8 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
I suppose you could download the program from their website: http://hsqldb.org/  It says that "HSQLDB is included with OOo and LibreOffice".
0
 
PortletPaulCommented:
see: Running the HSQL Database Manager

http://www.ibm.com/developerworks/library/os-echsql/
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
jazzIIIloveAuthor Commented:
The issue is that I know there is an instance running bug don't know how to reach the content?

Regards.
0
 
PortletPaulCommented:
there is a 'database manager' that comes with the product - this is a way to reach the content - that's why I suggested the link above
The Database Manager is an AWT application (see Figure 8), which will create its own event thread
have to admit I've not tried it, but this didn't look too complex
0
 
CEHJCommented:
The issue is that I know there is an instance running bug don't know how to reach the content?
Can't you just ask the person in charge of starting it? ;)

If you can't, you might like to enumerate the running processes and look at the command parameters to the java processes. See the following (you might like to use the 'ProcessExplorer' utility referred to instead of Powershell)

http://mohundro.com/blog/2010/02/05/quickly-get-the-command-line-arguments-from-processes-with-powershell/
0
 
jazzIIIloveAuthor Commented:
Hi;

I am actually stuck at the swing screen with:
URL: jdbc:hsqldb:mem:.

The program is running under memory but i don't know what the URL is. I know username and password but not the URL..How can I find this?

Regards.
0
 
PortletPaulCommented:
I don't know to be honest, but there should be some jdbc connection string that would reveal this - possibly in an xml file

this may give you some clues what to look for (maybe)
http://blog.networkedcollaboration.com/2012/03/15/accessing-hsql-database-manager/
0
 
CEHJCommented:
Did you look for Java processes as i suggested?
0
 
jazzIIIloveAuthor Commented:
Hi CEHJ;

Yes. I checked. There is no command line argument in the image tab.

Regards.
0
 
PortletPaulCommented:
what O/S is being used? Linux? Windows? SomePhone/TabletOS?

e.g. In the windows task manager, process tab, include 'command line' as a column (View > Select Columns)
0
 
jazzIIIloveAuthor Commented:
windows
0
 
PortletPaulCommented:
did the command line trick in task manager help at all?
0
 
CEHJCommented:
What java processes did you see and what were their command line arguments?
0
 
jazzIIIloveAuthor Commented:
I see my process under tomcat. The path of the tomcat executable + //BB//MySite

So, what's next then?

Regards.
0
 
CEHJCommented:
I see my process under tomcat. The path of the tomcat executable + //BB//MySite
No - you should be looking for a process called 'java'
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 5
  • 5
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now