Tables are not created in oracle db for activiti engine

[srikanthkollipa]

HI,

I am using activiti: 5.12.1 and grails 2.3.5. I have configured the datasource to point to oracle DB. But the problem is the activiti tables are not getting created and its throwing the exception that "invalid data type". It is just creating only 6 tables and others are not getting created because of the error.

On debugging further into this, found that there are few data types like bit, boolean are used in create statements and the oracle is not supporting these data types. Few tables that are having this problem are ACT_GE_BYTEARRAY, ACT_RU_JOB


Please help me in resolving this as I am pretty new to grails. Any help is appreciated.

Thanks,
Srikanth

[trademak]

Activiti 5.12.1 is old, really old. Are you sure you configured the right databaseType in your process engine configuration?

Best regards,

[srikanthkollipa]

Hi,

Thanks for the quick response.

From the grails site, 5.12.1 is the latest one.

Grails Activiti Plugin - Enabled Activiti BPM Suite support for Grails
Tags: workflow, bpm, bpmn, activiti Latest: 5.12.1 Last Updated: 03 June 2013 Grails version: 2.0.0 > *
Authors: Lim Chee Kin License: Apache License 2.0

If not, can you please let me know the latest version?

Regarding the databaseType, i configured it as oracle. And as I said, it is creating few tables around 6.

[srikanthkollipa]

I found the root cause for this issue. activiti plugin is looking for the 'datasource' in datasource.groovy file. But my grails application has multiple datasources and for avtiviti we have created the separate datasource named 'datasource_activiti'. In config.groovy activiti section, I mentioned this datasource name, but even then the activiti plugin is still not taking the datasource that i configured and hence not creating the tables in that DB. Can any one please help me in resolving this as it is required on high priority. Any help is much appreciated. Thanks.

[jbarrez]

Like Tijs said, 5.12 is really old. I would not use it, it seems the Grails plugin has not been maintained for a long time.