?
Solved

hsqldb viewer

Posted on 2013-05-28
19
Medium Priority
?
822 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 252 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 996 total points
ID: 39200513
0
 
LVL 49

Accepted Solution

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

http://www.ibm.com/developerworks/library/os-echsql/
0
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
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 49

Assisted Solution

by:PortletPaul
PortletPaul earned 752 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 996 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 49

Assisted Solution

by:PortletPaul
PortletPaul earned 752 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 49

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 49

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 996 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 996 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this article, we’ll look at how to deploy ProxySQL.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
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…

771 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