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">














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







      HSQDB UI :

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



      (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.