Details
-
Bug
-
Resolution: Obsolete
-
Blocker
-
jBPM 5.3
-
None
Description
Set jBPM to use oracle persistence
Create a simple process (start task, script task(hello world), end terminate event)
When runing through the jbpm-console, this process is always in running mode. the PROCESSINSTANCELOG entry never updates the "end_date".
Doing the same on a jBPM->connected to SQL Server the process is tagged as completed.
After checking the log file with "show_sql" turned on, I found out that is missing an update sql statement:
SQL Server:
...
14:21:08,374 INFO [stdout] (http--0.0.0.0-8080-3) Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?
14:21:08,393 INFO [stdout] (http--0.0.0.0-8080-3) Hibernate: update ProcessInstanceLog set end_date=?, processId=?, processInstanceId=?, start_date=? where id=?
14:21:08,408 INFO [stdout] (http--0.0.0.0-8080-3) Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?
...
Oracle:
13:54:14,926 INFO [stdout] (http-localhost-127.0.0.1-8080-2) Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?
13:54:15,133 INFO [stdout] (http-localhost-127.0.0.1-8080-2) Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?