6 Replies Latest reply on Jun 3, 2004 5:52 PM by drleon

    hsqldb error - Table not found

    dm

      I am working on Ch. 3 of http://www.tusc.com.au/tutorial/html/chap3.html tutorial. When I run the test client which makes a simple query to access the Hypersonic database through a DAO object, I get the Exception:

      2004-04-27 10:38:09,056 ERROR [STDERR] java.sql.SQLException: Table not found: STOREACCESS in statement [select userid from storeaccess where username = 'ANDY'and password = 'PASSWD']^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.Trace.getError(Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.Result.(Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.jdbcConnection.executeHSQL(Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.jdbcConnection.execute(Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.jdbcStatement.fetchResult(
      Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.jdbcStatement.executeQuery
      (Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.hsqldb.jdbcPreparedStatement.exec
      uteQuery(Unknown Source)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.Wrapp
      edPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)^M
      2004-04-27 10:38:09,066 ERROR [STDERR] at com.doug.dao.StoreAccessDAOImpl.login
      User(StoreAccessDAOImpl.java:53)^M

      The Exception is thrown when the executeQuery is called.

      The table exists and I can query it successfully through the web service.

      Thanks for your help.

      dm