[jboss-user] [Beginner's Corner] - JBoss and HSQLDB User Interface

[nilabhra banerjee]

nilabhra banerjee [https://community.jboss.org/people/nill] created the discussion

"JBoss and HSQLDB User Interface"

To view the discussion, visit: https://community.jboss.org/message/752794#752794

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

Reply to this message by going to Community
[https://community.jboss.org/message/752794#752794]

Start a new discussion in Beginner's Corner at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120809/9c0ac136/attachment-0001.html