What database browser can we use with HSQL-mem?

[Fred Janon]

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

[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

[Thomas W.-2]

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

[Erik Pragt]

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

[Fred Janon]

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

[kitplummer]

Anyone know if this went anywhere?

Kit

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:[e-mail]]
Sent: zondag 20 juli 2008 12:04
To: [e-mail]
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 <[e-mail]> 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