Deploying websale example

[anituarun]

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?

[koen.aers]

There is probably a jdbc driver conflict on your hsqldb database. Make sure to use the correct database jar.

Regards,
Koen

[anituarun]

I copied the hsqldb.jar that comes with jbpm-starters-kit to the default/lib folder of my JBoss instance. So, I think I am using the same version of hsqldb.jar; but I still get the same error.

[yiminzheng]

you need JBPM database schema created in the hsqldb database. run jbpm-db\hsqldb\upgrade.scripts\hsqldb.create.jbpm.3.1.sql if you will. and you need to deploy the websale process also. by running "ant deploy.processes -buildfile build.deploy.xml" under jbpm/