Anyone know of a viewing tool for the in memory db?

[jlo_gestalt]

Does anybody know of a viewing/monitoring tool available for the memory database for hsqldb?
I have used jboss cache in the past and they had a sweet tool (JbossCacheView2) that allowed you to see their in-memory database.

It would be handy to have, to see how grails creates the tables and stuff. I am old school db guy and its still hard for me to give that up and just trust it's being done right or the way I expect it to be done.

[Christian Laakmann]

HSQLDB actually has its own small viewing/monitoring/management application.

In your IDE, create a start configuration for this class: org.hsqldb.util.DatabaseManagerSwing with the hsqldb.jar in your classpath.

Then, in the upcoming window set the connection string to the string in your Grails-App and off you go.

Cheers
Christian

jlo_gestalt wrote:

Does anybody know of a viewing/monitoring tool available for the memory database for hsqldb?
I have used jboss cache in the past and they had a sweet tool (JbossCacheView2) that allowed you to see their in-memory database.

It would be handy to have, to see how grails creates the tables and stuff. I am old school db guy and its still hard for me to give that up and just trust it's being done right or the way I expect it to be done.

[jlo_gestalt]

I finally got around to trying this and I am unable to see any of my tables.
I create my configuration and the Database Manager opens up. I paste my development url in and click ok, but I don't see any of my tables. The screen says Ready with no errors, but no tables. And I have already started my grails app with grails run-app. I know I am in development mode so that can't be the problem.

Here are the values I give the db manager:
type: HSQL Database Engine In-Memory
driver: org.hsqldb.jdbcDriver
url: jdbc:hsqldb:mem:devDB
user: sa

I have even tried starting my grails app in production mode and connect to that db, but that doesn't appear to be working either.


HSQLDB actually has its own small viewing/monitoring/management application.

In your IDE, create a start configuration for this class: org.hsqldb.util.DatabaseManagerSwing with the hsqldb.jar in your classpath.

Then, in the upcoming window set the connection string to the string in your Grails-App and off you go.

Cheers
Christian

jlo_gestalt wrote:

Does anybody know of a viewing/monitoring tool available for the memory database for hsqldb?
I have used jboss cache in the past and they had a sweet tool (JbossCacheView2) that allowed you to see their in-memory database.

It would be handy to have, to see how grails creates the tables and stuff. I am old school db guy and its still hard for me to give that up and just trust it's being done right or the way I expect it to be done.

[Helmut Denk]

hi,

i can view prodDb with DBVisualizer

select 'HSQLDB embedded' as jdbc-driver and a url like this:
jdbc:hsqldb:file:{your-grails-app-base-dir}/prodDb

nevertheless - it would be nice to view the in-memory-db
too ...

have a nice day

I finally got around to trying this and I am unable to see any of my tables.
I create my configuration and the Database Manager opens up. I paste my development url in and click ok, but I don't see any of my tables. The screen says Ready with no errors, but no tables. And I have already started my grails app with grails run-app. I know I am in development mode so that can't be the problem.

Here are the values I give the db manager:
type: HSQL Database Engine In-Memory
driver: org.hsqldb.jdbcDriver
url: jdbc:hsqldb:mem:devDB
user: sa

I have even tried starting my grails app in production mode and connect to that db, but that doesn't appear to be working either.

[Helmut Denk]

i just saw, that james published a detailed description of
this in his blog:

http://jlorenzen.blogspot.com/2008/01/how-to-connect-to-grails-hsql-database.html

thanks for this convenience


hi,

i can view prodDb with DBVisualizer

select 'HSQLDB embedded' as jdbc-driver and a url like this:
jdbc:hsqldb:file:{your-grails-app-base-dir}/prodDb

nevertheless - it would be nice to view the in-memory-db
too ...

have a nice day

I finally got around to trying this and I am unable to see any of my tables.
I create my configuration and the Database Manager opens up. I paste my development url in and click ok, but I don't see any of my tables. The screen says Ready with no errors, but no tables. And I have already started my grails app with grails run-app. I know I am in development mode so that can't be the problem.

Here are the values I give the db manager:
type: HSQL Database Engine In-Memory
driver: org.hsqldb.jdbcDriver
url: jdbc:hsqldb:mem:devDB
user: sa

I have even tried starting my grails app in production mode and connect to that db, but that doesn't appear to be working either.

[baha007]

Hi guys,

I was able to connect to a file hslqdb instance as mentioned in james blog below. The problem is i'm trying to use the database development perspective in Eclipse to connect to the db. I read somewhere that the hsqldb driver is not closing the connection as long as the JVM is still running, so I have to restart Eclipse to liberate the db lock from the process that's locking the db. Do anyone know how to actually kill the process that's locking the db resources manually? everytime i try to connect through the db development prespective, I can't run the jetty server running the grails app or run any tests. The error i get is:

Could not connect to Grails Development.
  Error creating SQL Model Connection connection to Grails Development. (Error: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck)
  The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck
  Error creating HSQLDB Connection Factory connection to Grails Development. (Error: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck)
  The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck


Regards,

Baha



i just saw, that james published a detailed description of
this in his blog:

http://jlorenzen.blogspot.com/2008/01/how-to-connect-to-grails-hsql-database.html

thanks for this convenience

Helmut Denk wrote:

hi,

i can view prodDb with DBVisualizer

select 'HSQLDB embedded' as jdbc-driver and a url like this:
jdbc:hsqldb:file:{your-grails-app-base-dir}/prodDb

nevertheless - it would be nice to view the in-memory-db
too ...

have a nice day

I finally got around to trying this and I am unable to see any of my tables.
I create my configuration and the Database Manager opens up. I paste my development url in and click ok, but I don't see any of my tables. The screen says Ready with no errors, but no tables. And I have already started my grails app with grails run-app. I know I am in development mode so that can't be the problem.

Here are the values I give the db manager:
type: HSQL Database Engine In-Memory
driver: org.hsqldb.jdbcDriver
url: jdbc:hsqldb:mem:devDB
user: sa

I have even tried starting my grails app in production mode and connect to that db, but that doesn't appear to be working either.

[kitplummer]

I've got the same error message, following James' instructions.  What's changed to not release the lock?

Ugh...

Kit


Hi guys,

I was able to connect to a file hslqdb instance as mentioned in james blog below. The problem is i'm trying to use the database development perspective in Eclipse to connect to the db. I read somewhere that the hsqldb driver is not closing the connection as long as the JVM is still running, so I have to restart Eclipse to liberate the db lock from the process that's locking the db. Do anyone know how to actually kill the process that's locking the db resources manually? everytime i try to connect through the db development prespective, I can't run the jetty server running the grails app or run any tests. The error i get is:

Could not connect to Grails Development.
  Error creating SQL Model Connection connection to Grails Development. (Error: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck)
  The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck
  Error creating HSQLDB Connection Factory connection to Grails Development. (Error: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck)
  The database is already in use by another process: org.hsqldb.persist.NIOLockFile@cf87c0e3[file =C:\path\to\hsql\location\devDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\path\to\hsql\location\devDB.lck


Regards,

Baha



i just saw, that james published a detailed description of
this in his blog:

http://jlorenzen.blogspot.com/2008/01/how-to-connect-to-grails-hsql-database.html

thanks for this convenience

Helmut Denk wrote:

hi,

i can view prodDb with DBVisualizer

select 'HSQLDB embedded' as jdbc-driver and a url like this:
jdbc:hsqldb:file:{your-grails-app-base-dir}/prodDb

nevertheless - it would be nice to view the in-memory-db
too ...

have a nice day

I finally got around to trying this and I am unable to see any of my tables.
I create my configuration and the Database Manager opens up. I paste my development url in and click ok, but I don't see any of my tables. The screen says Ready with no errors, but no tables. And I have already started my grails app with grails run-app. I know I am in development mode so that can't be the problem.

Here are the values I give the db manager:
type: HSQL Database Engine In-Memory
driver: org.hsqldb.jdbcDriver
url: jdbc:hsqldb:mem:devDB
user: sa

I have even tried starting my grails app in production mode and connect to that db, but that doesn't appear to be working either.