JBoss and HSQLDB User Interface

[nill]

I have recently put hsqldb to keep data in memory. I configured JBOSS standalone-full.xml to run. (The config snippet is given below)

When I start my JBoss application I am able to create tables and do data operations on those tables easily....but while my application is running, I also wish to see the tables and the data in an user interface. I tried to use Squirrel and HSqldb swing. These instances are connecting to the database but not showing any element I created, not even the schema I am using.

Config snippet

*****************

                <datasource jta="true" jndi-name="java:/InMemoryDB" pool-name="InMemoryDB" enabled="true" use-java-context="true" use-ccm="true">

                    <connection-url>jdbc:hsqldb:mem:inmemorydb</connection-url>

                    <driver>hsqldb</driver>

                    <pool>

                        <min-pool-size>10</min-pool-size>

                        <max-pool-size>100</max-pool-size>

                        <prefill>true</prefill>

                        <flush-strategy>FailingConnectionOnly</flush-strategy>

                    </pool>

                    <security>

                        <user-name>sa</user-name>

                    </security>

                </datasource>

                <drivers>

                   <driver name="hsqldb" module="org.hsqldb">

                        <driver-class>org.hsqldb.jdbcDriver</driver-class>

                    </driver>

                </drivers>

            </datasources>

**********************

HSQDB UI :

c:\jboss-as-7.1.1.Final\modules\org\hsqldb\main>java -cp hsqldb.jar org.hsqldb.u

til.DatabaseManagerSwing

(Same jar locations as in JBoss)

Done similarly in Squirrel.

url I tried with

a) jdbc:hsqldb:mem:inmemorydb://localhost:1701

b) jdbc:hsqldb:mem:inmemorydb

I am using "sa"/"<blank>" as user credentials everywhere.

*****************************

Can anybody find out what wrong I am doing ?

Thanks a ton in advance for helping me out.

[jbertram]

This is really a question for the HSQLDB community rather than the JBoss community, but I'll venture an answer...

I believe the problem is that you're using an in memory database which is not accessible outside of the JVM.  As page 3 of the HSQLDB manual states:

For most applications, in-process access is faster, as the data is not converted and sent over the network. The main

drawback is that it is not possible by default to connect to the database from outside your application. As a result

you cannot check the contents of the database with external tools such as Database Manager while your application

is running.