3 Replies Latest reply on Mar 10, 2006 4:31 PM by yimin zheng

    Deploying websale example

    anituarun Newbie

      I tried to deploy the websale example that comes with the jbpm-starters-kit3.1 on JBoss4.0.3RC1. I copied jbpm.war and jbpm.sar to the deploy folder of my JBoss instance. When I start the server, I get the following error:

      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.D
      UEDATE_ asc]
      at org.hsqldb.jdbc.Util.throwError(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:312)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:172)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
      at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
      ... 6 more
      16:43:50,132 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:43:55,132 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002

      What am I doing wrong?