Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

hsqldb viewer

Posted on 2013-05-28
19
780 Views
Last Modified: 2013-12-02
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
Comment
Question by:jazzIIIlove
  • 5
  • 5
  • 5
  • +1
19 Comments
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 63 total points
ID: 39200494
I suppose you could download the program from their website: http://hsqldb.org/  It says that "HSQLDB is included with OOo and LibreOffice".
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 249 total points
ID: 39200513
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 188 total points
ID: 39200529
see: Running the HSQL Database Manager

http://www.ibm.com/developerworks/library/os-echsql/
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39200570
The issue is that I know there is an instance running bug don't know how to reach the content?

Regards.
0
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 188 total points
ID: 39200583
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
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 249 total points
ID: 39200866
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
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39201235
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
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 188 total points
ID: 39201272
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
 
LVL 86

Expert Comment

by:CEHJ
ID: 39201474
Did you look for Java processes as i suggested?
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39203617
Hi CEHJ;

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

Regards.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39203763
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
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39207299
windows
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39207344
did the command line trick in task manager help at all?
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 249 total points
ID: 39207393
What java processes did you see and what were their command line arguments?
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39207601
I see my process under tomcat. The path of the tomcat executable + //BB//MySite

So, what's next then?

Regards.
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 249 total points
ID: 39224978
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question