JBoss and HSQLDB User Interface
nill Aug 9, 2012 6:06 AMI 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.