Solved

hsqldb viewer

Posted on 2013-05-28
19
767 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AWS RDS Backups? 3 36
tomcat startup error 5 59
paypal ipn to mysql 3 35
FrontEnd tools to create web database application 7 53
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
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…

816 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now