1 Reply Latest reply on Aug 9, 2012 11:13 AM by Justin Bertram

    JBoss and HSQLDB User Interface

    nilabhra banerjee Newbie

      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.

        • 1. Re: JBoss and HSQLDB User Interface
          Justin Bertram Master

          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.