1
Vote

GenericPersistenceService - Oracle 9i Scripts

description

Hi,
 
I was facing some problems try to run WFTools 0.3.0.0 (15876) with Oracle 9i.
Some persisted workflows weren't loading after expired timers, i found that some statements in WHERE clauses of procedures RetrieveNonblockingInstanceIds, RetrieveExpiredTimerIds and RetrieveInstanceState were causing that problem.
The statement (OWNED_UNTIL < SYS_EXTRACT_UTC(SYSTIMESTAMP)) must be changed to (to_timestamp(OWNED_UNTIL) < SYS_EXTRACT_UTC(SYSTIMESTAMP)). After this the problem was solved.

comments