« Return to Thread: What database browser can we use with HSQL-mem?

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

by Fred Janon :: Rate this Message:

Hi Erik,

Thanks for the tip. I wonder what it would take to get Grails to start an HSQL server instead of what it's doing now, so we don't have to do this extra work. It would be great to just connect to the HSQL mem or file DB created by Grails with a DB browser without doing anything extra. Starting an external DB server is what I used to do and continue to do, unfortunately. I might submit a feature request if there is no more answers. I would make prototyping so much easier for me.

Cheers,

Fred

On Sun, Jul 20, 2008 at 19:10, Erik Pragt <erik@...> 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@...]
Sent: zondag 20 juli 2008 12:04
To: user@...
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@...> 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

« Return to Thread: What database browser can we use with HSQL-mem?