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

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