Database view page is empty (Oracle)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2012 09:33 AM
Dear Users,
I have a problem in Activiti Explorer. Database view page is empty when activiti engine 5.9 is running on Oracle database 10.
I have an mistake:
I have discovered that in the Activiti Engine exist a class called TableDataManager.It's method getTableCount() trows this exception at the moment it tryes to run getTablesPresentInDatabase() method which has code:
I find that if i modify SQL to
You already have special tableNameFilter for "postgres"
Maybe it would be better to create a JIRA, but anyway i've decided to ask first at forum.
Thanks,
Alexander
I have a problem in Activiti Explorer. Database view page is empty when activiti engine 5.9 is running on Oracle database 10.
I have an mistake:
com.vaadin.event.ListenerMethod$MethodExceptionCause: org.activiti.engine.ActivitiException: couldn't get table countsat com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
I have discovered that in the Activiti Engine exist a class called TableDataManager.It's method getTableCount() trows this exception at the moment it tryes to run getTablesPresentInDatabase() method which has code:
try { log.fine("retrieving activiti tables from jdbc metadata"); String tableNameFilter = "ACT_%"; if ("postgres".equals(getDbSqlSession().getDbSqlSessionFactory().getDatabaseType())) { tableNameFilter = "act_%"; } tables = databaseMetaData.getTables(null, null, tableNameFilter, getDbSqlSession().JDBC_METADATA_TABLE_TYPES);
Underscore is a symbol of Oracle grammar.I've tryed to run simple SQL on my database:select *FROM all_tablesWHERE TABLE_NAME LIKE 'ACT_%'
It returns not only tables which starts with ACT_ but also other tables which starts with act.I find that if i modify SQL to
select *FROM all_tablesWHERE TABLE_NAME LIKE 'ACT_\%' ESCAPE '\'
It returns only ACT tables as it should. You already have special tableNameFilter for "postgres"
if ("postgres".equals(getDbSqlSession().getDbSqlSessionFactory().getDatabaseType())) {tableNameFilter = "act_%";}
Is it possible to introduce special logic for Oracle like if ("oracle".equals(getDbSqlSession().getDbSqlSessionFactory().getDatabaseType())) {tableNameFilter = "ACT_\% ESCAPE '\' ";}
Or do you have any other suggestion how to solve with issue?Maybe it would be better to create a JIRA, but anyway i've decided to ask first at forum.
Thanks,
Alexander
Labels:
- Labels:
-
Archive
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2012 04:41 PM
I am running into the same problem when I connect to Oracle and run the demo.
I am evaluating Activiti for my company and not sure this would be a problem in a production environment, but is it something that the development team is willing to address in a patch?
Thanks.
I am evaluating Activiti for my company and not sure this would be a problem in a production environment, but is it something that the development team is willing to address in a patch?
Thanks.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-14-2012 10:11 AM
Hi,
I had the same problem when I started activity 5.9 demo on my Oracle Database XE 11.2.
But in this database I had two different schemas for Activity (users and tables) for version 5.8 and 5.9
When the old tables was deleted - it works fine.
Best regards,
tomili
I had the same problem when I started activity 5.9 demo on my Oracle Database XE 11.2.
But in this database I had two different schemas for Activity (users and tables) for version 5.8 and 5.9
When the old tables was deleted - it works fine.
Best regards,
tomili

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2012 01:58 PM
Same problem here - Please can you fix this?
activiti-5.9/setup/files/dependencies/libs/org/activity/activiti-engine-5.9-sources.jar:
engine/impl/persistence/entity/TableDataManager.java:
2 fixes:
1. Escape the '\': …. where table_name like 'ACT\_%' ESCAPE '\';
2. Look at user_tables instead of all_tables.
Please?
activiti-5.9/setup/files/dependencies/libs/org/activity/activiti-engine-5.9-sources.jar:
engine/impl/persistence/entity/TableDataManager.java:
2 fixes:
1. Escape the '\': …. where table_name like 'ACT\_%' ESCAPE '\';
2. Look at user_tables instead of all_tables.
Please?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2012 03:30 AM
Can you create a JIRA-issue with the proposed solution elaborated a bit more? That would be great…

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2012 03:53 PM
Can you create a JIRA-issue with the proposed solution elaborated a bit more? That would be great…
Good idea. Created http://jira.codehaus.org/browse/ACT-1404 , heavily quoting Alexander's excellent findings above.
- Christian
