9:43 a.m.
"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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...