Re: [Squirrel-sql-users] Hsql

[gwg <gw...@co...>]

Mike,
    Even though I am new to Squirrel, I may be an appropriate person to 
answer this question since I just worked through this same problem last 
week.  I'm cc'ing the squirrel-sql-users list in case other people have 
the same problem.

    The answer depends a bit on what flavor of hsql you are using.  If 
you cd to the directory containing the hsqldb.jar file and type:
    java -cp hsqldb.jar org.hsqldb.util.DatabaseManager
you will get a window for an hsqldb tool that is trying to do the same 
job as Squirrel.  In this window, there are many different database 
engines listed, including 4 different flavors of hsql.  These are:
    - in-memory  (url=jdbc:hsqldb:.)
    - stand-alone (url=jdbc:hsqldb:test)
    - server  (url=jdbc:hsqldb:hsql://localhost)
    - WebServer (url=jdbc:hsqldb:hsql://localhost)
I assume that all of those URLs need to be adjusted appropriately (e.g. 
by adding or changing a database name, etc.)

All 4 hsql flavors use the driver named org.hsqldb.jdbcDriver

On my system (linux) with JBoss running (which starts hsqldb by 
default), I was able to set up squirrel (see below)  using:
    driver = org.hsqldb.jdbcDriver
    port = 1476
    url = jdbc:hsqldb:hsql:@localhost:1476:myDatabaseName

By the way, the default user/login for hsqldb is
    user = sa
    no password

The squirrel set up is in two parts.  First you need to use the 
"Drivers" window to create a template of what hsqldb connections look 
like in general.  IMHO the window is misnamed; I think it should be 
something like "Connection Templates".

Once you have created the template for hsql connections, go to the 
"Alias" window (which I think should be named something like "Available 
DBs" or "Real DB Connection Descriptions") and create the description of 
the connection to the actual DB that you are using.  Once the 
description is created in the "Alias" window, you should be able to use 
it to connect to the DB.

Hope this helps.

Glenn Griffin
gw...@co...

Mike G. Hammonds wrote:

>How do I add connect to a HSQL database?
>
>Mike Hammonds
>Fellon-McCord & Associates, Inc.
>Information Services Manager
>Voice (502) 214-6324 Fax (502)426-8800
>mha...@kn... <mailto:mha...@kn... >
> 
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Squirrel-sql-users mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>