"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': [EMAIL PROTECTED]
| 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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
