[jboss-user] [JBoss jBPM] - Re: Please help me, 'scheduler' unavailable ??

[EugeneV]

"kukeltje" wrote : I think, but the chance that I'm wrong is high, that there is no hibernate on the classpath.

You are right! I was under the wrong impression that a default Process Project created with the jBPM plugin would contain all dependencies, but hibernate is not there. I added hibernate3.jar and now I see:


  | 10:33:19,208 [main] DEBUG Scheduler : starting the scheduler
  | 10:33:19,239 [main] INFO  JbpmConfiguration : using jbpm configuration resource 'jbpm.cfg.xml'
  | 10:33:19,239 [main] DEBUG JbpmConfiguration : loading defaults in jbpm configuration
  | 
  | ...
  | 
  | 10:33:19,786 [JbpmScheduler] DEBUG JbpmContextInfo : creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
  | 10:33:19,786 [JbpmScheduler] DEBUG JbpmContext : creating JbpmContext
  | 10:33:19,786 [JbpmScheduler] DEBUG DbPersistenceServiceFactory : creating persistence service
  | 10:33:19,786 [JbpmScheduler] DEBUG DbPersistenceServiceFactory : building hibernate session factory
  | 10:33:19,833 [JbpmScheduler] INFO  Environment : Hibernate 3.1
  | 10:33:19,849 [JbpmScheduler] INFO  Environment : hibernate.properties not found
  | 10:33:19,849 [JbpmScheduler] INFO  Environment : using CGLIB reflection optimizer
  | 10:33:19,864 [JbpmScheduler] INFO  Environment : using JDK 1.4 java.sql.Timestamp handling
  | 10:33:19,958 [JbpmScheduler] DEBUG HibernateHelper : creating hibernate configuration resource 'hibernate.cfg.xml'
  | 10:33:19,958 [JbpmScheduler] INFO  Configuration : configuring from resource: hibernate.cfg.xml
  | 10:33:19,958 [JbpmScheduler] INFO  Configuration : Configuration resource: hibernate.cfg.xml
  | 
  | ...
  | 
  | 10:33:23,114 [JbpmScheduler] INFO  DriverManagerConnectionProvider : Using Hibernate built-in connection pool (not for production use!)
  | 10:33:23,114 [JbpmScheduler] INFO  DriverManagerConnectionProvider : Hibernate connection pool size: 20
  | 10:33:23,114 [JbpmScheduler] INFO  DriverManagerConnectionProvider : autocommit mode: false
  | 10:33:23,114 [JbpmScheduler] INFO  DriverManagerConnectionProvider : using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:mem:.;sql.enforce_strict_size=true
  | 10:33:23,114 [JbpmScheduler] INFO  DriverManagerConnectionProvider : connection properties: {user=sa, password=****}
  | 10:33:23,474 [JbpmScheduler] INFO  SettingsFactory : RDBMS: HSQL Database Engine, version: 1.8.0
  | 10:33:23,474 [JbpmScheduler] INFO  SettingsFactory : JDBC driver: HSQL Database Engine Driver, version: 1.8.0
  | 10:33:23,489 [JbpmScheduler] INFO  Dialect : Using dialect: org.hibernate.dialect.HSQLDialect
  | 10:33:23,505 [JbpmScheduler] INFO  TransactionFactoryFactory : Using default transaction strategy (direct JDBC transactions)
  | 10:33:23,505 [JbpmScheduler] INFO  TransactionManagerLookupFactory : No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  | 
  | ...
  | 
  | 10:33:26,145 [JbpmScheduler] INFO  SessionFactoryObjectFactory : Not binding factory to JNDI, no JNDI name configured
  | 10:33:26,145 [JbpmScheduler] INFO  SessionFactoryImpl : Checking 28 named HQL queries
  | 10:33:26,614 [JbpmScheduler] INFO  SessionFactoryImpl : Checking 0 named SQL queries
  | 10:33:26,614 [JbpmScheduler] DEBUG DbPersistenceService : creating hibernate session
  | 10:33:26,677 [JbpmScheduler] DEBUG DbPersistenceService : beginning hibernate transaction
  | 10:33:26,692 [JbpmScheduler] DEBUG SchedulerThread : checking for timers
  | 10:33:26,724 [JbpmScheduler] WARN  JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
  | 10:33:26,724 [JbpmScheduler] 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]
  | 10:33:26,724 [JbpmScheduler] ERROR SchedulerSession : org.hibernate.exception.SQLGrammarException: could not execute query using iterate
  | 10:33:26,724 [JbpmScheduler] DEBUG JbpmContext : closing JbpmContext
  | 10:33:26,724 [JbpmScheduler] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService at 19a37a
  | 10:33:26,724 [JbpmScheduler] DEBUG DbPersistenceService : committing hibernate transaction
  | 10:33:26,724 [JbpmScheduler] DEBUG DbPersistenceService : closing hibernate session
  | 10:33:26,724 [JbpmScheduler] 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:410)
  | 	at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:310)
  | 	at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:170)
  | 	at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1139)
  | 	at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
  | 	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:442)
  | 	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
  | 	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)
  | 	... 7 more
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3984936#3984936

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3984936