1 Reply Latest reply on Jun 7, 2004 2:04 PM by sys user

    Need help on connecting to external hsqldb

    sys user Master

      I am using JBoss 3.2.3/Tomcat 5.0.16 with external hsql db.

      Got an outofmemory error while trying to getConnection from the data source.
      The exception message is as follows.

      org.jboss.util.NestedSQLException: Could not create connection; - nested throwable:
      (java.sql.SQLException: No data is available); - nested throwable:

      The server is running with -Xms128m -Xmx512m
      The datasource is described as:

      <local-tx-datasource>
      <jndi-name>PersonDb</jndi-name>
      <connection-url>jdbc:hsqldb:hsql://localhost:8887</connection-url>
      <driver-class>org.hsqldb.jdbcDriver</driver-class>
      <user-name>sa</user-name>

      </local-tx-datasource>


      Did I miss some required config changes for connecting to external hsqldb ?
      Any help will be appreciated. Thanks in advance.

        • 1. Re: Need help on connecting to external hsqldb
          sys user Master

          Below is the stack trace:

          Caused by: java.sql.SQLException: No data is available
          at org.hsqldb.Trace.getError(Unknown Source)
          at org.hsqldb.Trace.error(Unknown Source)
          at org.hsqldb.jdbcResultSet.checkAvailable(Unknown Source)
          at org.hsqldb.jdbcResultSet.getString(Unknown Source)
          at org.hsqldb.jdbcConnection.isReadOnly(Unknown Source)
          at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.(BaseWrapperManagedConnection.java:98)
          at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.(LocalManagedConnection.java:57)
          at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:156)