LifeRay Portal under JBoss/Tomcat w/Hypersonic

[dmloring]

I've really got to be dense; connection strings are my downfall.

I thought I could access the Hypersonic DB that comes with JBoss AppServer.

I cannot seem to get my Hypersonic DB manager or Squirrel on my home Windows to talk to the HSQLDB in the JBoss in my Rimuhosting VPS.

In order just to see if it was running, I had to relax security to access jmx-console, which does report that an HSQL service is running that is not in-process.

And I've done the uncommenting and commenting of the XML file to use the TCP/IP version.

I've tried:
jdbc:hsqldb:hsql://<<MyIP>>:1701

alone and appending various paths.

But I still get lost in which name is which between services and databases etc

I get "Socket Creation Failure" and my JBoss logs say the Root MBean cause is "NOTYETINSTALLED".

I don't get it; when jmx-console says it is running.

[favourafolabi]

hi

steps to solve problem

1. you need to download hsqldb from hsqdb.com

2, extract into folder c:\hsqldb


3. set path to c:\hsqldb


4. create HSQLDB_HOME

5. GO TO c:\hsqldb\lib from dos prompt and run the following commmand

java -cp hsqldb.jar org.hsqldb.util.DatabaseManager

6. you will the hsqldb manager come up ; use the default user name and password, then type the name of the db you are tryin to access in the db name field, you will be able to access the hypersonic db, make updates, run queries, scripts, etc