topic Re: Current activiti engine broken for Oracle in Alfresco Archive

Current activiti engine broken for Oracle

krsmes — Fri, 18 Nov 2011 14:16:32 GMT

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.htmFor oracle it should be 'AC

Re: Current activiti engine broken for Oracle

trademak — Mon, 21 Nov 2011 10:25:29 GMT

Did you try the solution proposed here:

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

Best regards,

Re: Current activiti engine broken for Oracle

krsmes — Mon, 21 Nov 2011 14:14:06 GMT

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 _