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

What database browser can we use with HSQL-mem?

by Fred Janon :: Rate this Message:

Reply to Author | View in Thread

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?