(re-post from the Installation and Configuration forum)

Need help to get JBoss 3.2.3/Tomcat 5.0.16 to connect to an external hsqldb 1.6.1 database running on port 8887. I've searched the forums, but didn't find any solutions.

I added a my-hsqldb-ds.xml(see below) to my jboss server deploy directory, copied the hsqldb.jar from my hsqldb 1.6.1/bin to my jboss server/lib, also tried removing the existing hsqldb-ds.xml and the hsqldb-plugin.jar None of them worked !!

The data source showed up in jmx-console, but the Servlet fails to get connection from the data source. The stack trace in listed below.

What have I missed in the configuration ? Thanks in advance for your help.

my-hsqldb-ds.xml:

<local-tx-datasource>
<jndi-name>MyHsqlDb</jndi-name>
<connection-url>jdbc:hsqldb:hsql://127.0.0.1:8887</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>xxx</user-name>
xxx
</local-tx-datasource>


Stack trace:

WARN [http8080-Processor24] connectionmanager.JBossManagedConnectionPool.[] Jun/08 09:11:50 - Throwable while attempting to get a new connection:
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: No data is available)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)