I am running through the example getting started with jBPM examples on the
JBoss wiki. I modified the example app to have the following:
<state name="auction">
| <timer name="testTimer"
| duedate='1 business minutes'
| repeat='.5 business minutes'
| transition='time-out-transition' >
| <action class="com.jboss.test.Reminder"/>
| </timer>
| </state>
However, when I am running this as the default created project in Eclipse I get
the followiing error:
17:47:12,865 [main] DEBUG SchedulerThread : checking for timers
17:47:12,884 [main] WARN JDBCExceptionReporter : SQL Error: -22, SQLState:
S0002
17:47:12,884 [main] ERROR JDBCExceptionReporter : Table not found in statement
[select top ? timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where
(timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by
timer0_.DUEDATE_ asc]
17:47:12,885 [main] ERROR SchedulerSession :
org.hibernate.exception.SQLGrammarException: could not execute query using
iterate
17:47:12,885 [main] DEBUG JbpmContext : closing JbpmContext
17:47:12,886 [main] DEBUG Services : closing service 'persistence': [EMAIL
PROTECTED]
17:47:12,886 [main] DEBUG DbPersistenceService : committing hibernate
transaction
17:47:12,887 [main] DEBUG DbPersistenceService : closing hibernate session
17:47:12,888 [main] 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:99)
Looking at the source the code is trying to get the Timer table...but in
looking further up my stack of code I see this:
17:47:08,746 [main] INFO Configuration : Reading mappings from resource:
org/jbpm/scheduler/exe/Timer.hbm.xml
17:47:08,761 [main] INFO HbmBinder : Mapping class:
org.jbpm.scheduler.exe.Timer -> JBPM_TIMER
I have read through the forms and copied the contents of the jbpm.cfg.xml file
into my eclipse created jBPM project and also the hibernate.cfg.xml file.
If anyone can shed some light on what other knobs I need to twist to make this
work in a standalone environment.
Please note I have the following code running, and this is where the code that
can not find the Timer table is executed within:
| SchedulerThread scheduler = new SchedulerThread();
| scheduler.setInterval(2000);
| scheduler.run();
|
and this is from where the error is created.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3999656#3999656
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3999656
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
