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