0 Replies Latest reply on Aug 9, 2012 6:06 AM by nilabhra banerjee

    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.