AnsweredAssumed Answered

Current activiti engine broken for Oracle

Question asked by krsmes on Nov 18, 2011
Latest reply on Nov 21, 2011 by krsmes
There is code in activiti that is looking for "ACT_%" tables. This doesn't work for Oracle as _ is a wildcard and it is picking up ACTION_TABLE which it then tries unsuccessfully to do some other query on (count?).

http://www.dba-oracle.com/tips_oracle_escape_characters.htm

For oracle it should be 'ACT\_%' with the escape specified: ESCAPE '\'. Either that or come up with a more robust/generic way of getting a list of activiti tables than hard coding 'ACT_'.


Anyone have a workaround other than downloading and changing the source code?

Outcomes