topic Re: How to configure activiti on oracle database in Alfresco Archive

How to configure activiti on oracle database

mihirdas — Fri, 23 Mar 2012 14:12:55 GMT

I tried installation by changing db connection parameters at all property files and I have copied ojdbc14.jar to the required directories. But I am not able to succeed and i am getting following exception. Below are the DB parameters we have used and our oracle version is 10.2.DB properties we have

Re: How to configure activiti on oracle database

patelag — Mon, 17 Feb 2014 04:39:32 GMT

Dear Team,

I am facing below issue in integration of Activiti with Oracle 11g.

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

### The error may involve org.activiti.engine.impl.persistence.entity.ResourceEntity.insertResource-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) values (?, 1, ?, ?, ?, ?)
### Cause: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

It is working fine with H2 database.

Project Summary : I am using eclipse IDE for making one Proof Of Concept application. I have used Spring MVC. Application will invoke bpm process at certain interval using quartz scheduler.

Please find Activiti configuration for your information.

Please help.

Re: How to configure activiti on oracle database

trademak — Mon, 17 Feb 2014 13:44:56 GMT

Please post your question only once.

Re: How to configure activiti on oracle database

patelag — Fri, 21 Feb 2014 03:29:37 GMT

Issue is resolved after taking latest oracle driver (ojdbc6)
Thanks

Re: How to configure activiti on oracle database

sunilkumartk — Wed, 27 Apr 2016 03:04:37 GMT

I have a blogpost on Oracle DB Configuration
http://techsunils.blogspot.com/2016/04/activiti-bpmn-configure-oracle-database.html

or a Video

Activiti 5.22 Introduction and Installation - YouTube