topic Re: Problem with Database Management on Oracle in Alfresco Archive

Problem with Database Management on Oracle

junidb — Sun, 13 Nov 2011 14:40:15 GMT

When deploying on Oracle, the new Explorer throws this message when going to the Database tab of Management.### Error querying database. Cause: java.sql.SQLException: ORA-00942: table or view does not exist### The error may involve org.activiti.engine.impl.TablePageMap.selectTableCount-Inline### The

Re: Problem with Database Management on Oracle

krsmes — Fri, 18 Nov 2011 14:12:31 GMT

Adding a second vote to this question.

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_'.

FWIW, this does not seem to break activiti-explorer for some reason, but it does break when I run processEngine connected to oracle via a test case.

Activiti is unusable on Oracle at the moment unless I download the code a hack a workaround.

Re: Problem with Database Management on Oracle

junidb — Mon, 21 Nov 2011 05:16:33 GMT

New update: worked on 3 databases: development server, testing server and local machine. Problem occurs on testing server and local machine. But somehow working on development server. Will spend time checking what is different.

Re: Problem with Database Management on Oracle

junidb — Mon, 21 Nov 2011 08:48:51 GMT

Hi, found the problem. The problem occured because the DatabaseMetaData.getTables also include ACTION_TABLE, which comes from the Order Entry sample data. I deleted the OE user from my database and the application runs smoothly. HTH.

Re: Problem with Database Management on Oracle

marcthomas2012 — Tue, 20 Nov 2012 10:41:33 GMT

Are Activiti resolving this issue in the 5.11 release? It seems like a fairly straight forward issue and fix.

Can anyone from Activiti comment on this?

Thanks
Marc

Re: Problem with Database Management on Oracle

frederikherema1 — Wed, 21 Nov 2012 08:20:43 GMT

What "straight forward" fix do you propose, other than having a hard-coded list of table names in our code (which is what we wanted to avoid in the first placed and wanted to fix with the ACT_ prefix).

Re: Problem with Database Management on Oracle

marcthomas2012 — Wed, 21 Nov 2012 08:37:37 GMT

Sorry, I shouldn't have put "straight forward". However, the code works the way it does today apart from on Oracle so a temporary fix of verifying if it is running on Oracle to escape the _ character would be better than nothing.

Re: Problem with Database Management on Oracle

frederikherema1 — Wed, 21 Nov 2012 08:54:03 GMT

That's a good suggestion, seemed to missed that suggested fix in the previous comments.

Just fixed this on master, in time for 5.11:
https://github.com/Activiti/Activiti/commit/5340c0cb454ed990aae8057ca2d9ccddc998aced

Re: Problem with Database Management on Oracle

marcthomas2012 — Wed, 21 Nov 2012 10:07:41 GMT

That's fantastic news, thanks. Is 5.11 still on target for the beginning of December? There are a couple of changes in there that will be great to get.

Thanks again.
Marc

Re: Problem with Database Management on Oracle

frederikherema1 — Wed, 21 Nov 2012 10:15:09 GMT

It'll be released the first week of December (since the 1st of December is on a saturday)

Re: Problem with Database Management on Oracle

marcthomas2012 — Wed, 21 Nov 2012 10:25:50 GMT

Thank you for confirming.

Marc