3 Replies Latest reply on Dec 4, 2006 5:05 AM by misel

starters-kit: unable to deploy selfbuild jbpm.sar

gf_public Aug 16, 2006 10:47 AM

Hello

I am using everything from the starters-kit. I want to play arround in the jbpm code.

I can change the .jsp files and then

ant -f build.deploy.xml undeploy.webapp deploy.webapp

to move my changes to the server.

But when I try to do the same with the sar, it crashes. Let me say, that at the moment I didn't change any line in the jbpm code except a trivial change in the home.jsp. Its as "vanilla" as it comes with the starters-kit.

First I undeploy the war.

Then I try

ant -f build.deploy.xml undeploy.service.archive

which says BUILD SUCCESSFULL, but the jbpm.sar directory still exists in the deploy dir.

If I then try to

ant -f build.deploy.xml deploy.service.archive

JBoss is refusing and the BUILD FAILS

Trying to install an already registered mbean: jboss.jbpm:name=DefaultJbpm,service=JbpmService

I am pretty stuck here.

When i deleted the jbpm.sar directory in deploy it by hand (as i would do with a war file) the server is not saying, that it was undeployed.

So when i copied the newly build jbpm.sar.dir to the deploy:

cp build/jbpm.sar.dir ../jbpm-server/server/jbpm/deploy/jbpm.sar -R

JBoss ist saying:
16:37:31,100 INFO [JbpmConfiguration] using jbpm configuration resource 'jbpm.cfg.xml'

Aftewards, i try to deploy the war again:

ant -f build.deploy.xml deploy.webapp

And big stupid errors start apearing.... (I show then at the end)

PLEASE, tell someone tell me how to build and deploy jbpm from the starters-kit correctly.

i'm pretty sure that i set the environment variables and paths in build.properties correctly.

Thanks in advance, Gregor Fellenz

16:38:49,872 INFO [TomcatDeployer] deploy, ctxPath=/jbpm, warUrl=.../tmp/deploy/tmp26916jbpm.war/
16:38:50,862 DEBUG [ApplicationFactory] New ApplicationFactory instance created
16:38:50,866 ERROR [LocaleUtils] Locale name null or empty, ignoring
16:38:59,758 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
16:39:00,021 WARN [EhCacheProvider] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
16:39:01,149 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
16:39:01,616 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
16:39:02,206 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
16:39:02,225 WARN [EhCacheProvider] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
16:39:04,310 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
16:39:05,343 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
16:39:06,513 WARN [EhCacheProvider] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
16:39:09,817 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
16:39:10,829 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
16:39:10,902 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
16:39:10,905 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
16:39:10,906 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
16:39:10,906 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
16:39:10,907 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
16:39:10,907 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
16:39:10,908 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
16:39:10,909 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
16:39:10,915 WARN [EhCacheProvider] Could not find configuration [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
16:39:10,918 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
16:39:10,918 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
16:39:10,919 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
16:39:10,919 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
16:39:10,919 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
16:39:10,920 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
16:39:10,923 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event.actions]; using defaults.
16:39:10,924 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.events]; using defaults.
16:39:10,940 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.events]; using defaults.
16:39:10,940 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
16:39:10,941 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.SuperState.nodes]; using defaults.
16:39:10,941 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
16:39:10,941 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
16:39:10,942 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
16:39:10,942 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
16:39:10,947 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition.events]; using defaults.
16:39:14,132 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:14,132 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:14,133 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:14,134 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:14,146 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:14,147 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:14,147 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:19,137 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:19,138 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:19,138 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:19,138 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:19,149 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:19,152 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:19,152 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:24,142 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:24,142 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:24,143 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:24,143 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:24,158 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:24,158 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:24,158 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:29,150 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:29,150 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:29,150 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:29,151 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:29,166 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:29,166 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:29,167 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:34,170 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:34,170 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:34,170 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:34,171 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:34,174 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:34,174 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:34,174 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:39,174 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:39,175 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:39,175 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:39,176 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:39,178 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:39,178 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:39,179 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:44,179 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:44,179 ERROR [JDBCExceptionReporter] 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_.DUEDATE_ asc]
16:39:44,179 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:39:44,180 INFO [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
 at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
 at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
 at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
 at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
 at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
 at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
 ... 2 more
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_.DUEDATE_ asc]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 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:39:44,182 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:39:44,183 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
16:39:44,183 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execu

1. Re: starters-kit: unable to deploy selfbuild jbpm.sar

cpob Aug 16, 2006 11:11 AM (in response to gf_public)
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_.DUEDATE_ asc]

Your database doesn't look like it is built or set up right.
Actions
2. Re: starters-kit: unable to deploy selfbuild jbpm.sar

gf_public Aug 16, 2006 11:15 AM (in response to gf_public)

I know. But,
1. When I replace the selfbuild and deployed sar - directory with the one thaat was predeployed in the starters-kit, it works again
2. When I start the hsqldb databasemanager, the table exists (empty, but existing)
3. calling ant -f build.deploy.xml create.db doesn't help

Thanks anyway..
Gregor
Actions
3. Re: starters-kit: unable to deploy selfbuild jbpm.sar

misel Dec 4, 2006 5:05 AM (in response to gf_public)
Hi mate,
don't know if you solved the problem, but I had _exactly_ the same problem, i.e the database was up and running and all tables were created. After a lot of hair-pulling I finally discovered that the hibernate.cfg should be updated. So in

$JBPM_HOME/src/config.files/hibernate.cfg.xml

i replaced the jdbc properties



....

with

<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property> <property name="hibernate.connection.datasource">java:/DefaultDS</property>

(Then of course a build.deploy) and it finally worked.

Cheers,
ml
Actions

Go to original post