AnsweredAssumed Answered

Tables are not created in oracle db for activiti engine

Question asked by srikanthkollipara on Sep 1, 2015
Latest reply on Sep 4, 2015 by srikanthkollipara

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.