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:



      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)