Current activiti engine broken for Oracle

[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?

[trademak]

Did you try the solution proposed here:

http://forums.activiti.org/en/viewtopic.php?f=9&t=2901

Best regards,

[krsmes]

Yes, that workaround worked.  Thank you.

ACTION_TABLE seems to be some sort of 'invisible' nested inner table with that sample OE user.

I still believe that the search for ACT_% is a defect when using it against oracle due to oracle's special treatment of _