Solved

hsqldb viewer

Posted on 2013-05-28
19
783 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
[X]
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
  • 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Don't miss ATEN at NAB Show April 24-27!

Visit ATEN at NAB Show to learn how our "Seamlessly Entertaining" solutions deliver fast, precise video streaming without delays for the broadcasting and media environment. ATEN will showcase its 16x16 Modular Matrix Switch (VM1600) and KVM Over IP Solution (KE6900 series).

Question has a verified solution.

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

In this post we will learn different types of Android Layout and some basics of an Android App.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will learn how to implement Singleton Design Pattern in Java.

740 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