RE: Re: What database browser can we use with HSQL-mem?

Erik Pragt wrote:

Hi,
 
you can connnect to HSQLDB (e.g. by using Squirrel) by making a few changes
to the Grails configuration, and starting a HSQLDB database server
separately.
 
You can do so by changing the development database URL to
jdbc:hsqldb:hsql://localhost:9001/devDB, and open a new shell/console and go
to your Grails installation directory. There you can run the following
command:
 
java -cp ./lib/hsqldb-1.8.0.5.jar org.hsqldb.Server -database.0 mem:devDB
-dbname.0 devDB
 
which will start up a in memory database server which does allow connections
from external tools like Squirrel. This way you can explore the database
quite easiliy.
 
Hope this helps,
 
Erik


 

  _____  

From: Thomas Weuffel [mailto:mail@weuffel.com]
Sent: zondag 20 juli 2008 12:04
To: user@grails.codehaus.org
Subject: Re: [grails-user] Re: What database browser can we use with
HSQL-mem?


I would be interested in browsing the HSQLDB, too.
Any ideas about this?

Cheers,
Thomas


Am 20.07.2008 um 03:55 schrieb Fred Janon:


Any answer anyone on how to look at the Grails HSQL DB schema and data? Or
does it mean that no one is using HSQL for debugging??

Thanks

Fred


On Tue, Jul 15, 2008 at 12:29, Fred Janon <fjanon@gmail.com> wrote:


I used to use a mySQL DB and its SQL browser for development and production.
I wanted to give a shot at HSQL. I installed Squirrel DB Client (a free SQL
browser), connected to my Grails project DB successfully according to
Squirrel but I see no tables in Squirrel. The SQL log in Grails show objects
being created by Hibernate:

Hibernate:
    insert
    into
        place
        (id, version, address_id, descriptor_id, primary_contact_id)
    values
        (null, ?, ?, ?, ?)

I am not sure Hibernate flushed the objects from the cache in the DB since I
am using the default datasource config:

hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true
 
cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}

Anyone using Squirrel or another SQL db browser (free) with HSQL?

Thanks

Fred