0 Replies Latest reply on Jun 8, 2004 1:04 PM by sys user

    Need urgent help on connecting to external hsqldb database

    sys user Master

      (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)