[JBoss jBPM] - Re: Please help me, 'scheduler' unavailable ??
by 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@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
19Â years, 7Â months