How to configure activiti on oracle database

[mihirdas]

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 configured as follows:
db = oracle
jdbc.driver = oracle.jdbc.driver.OracleDriver
jdbc.url=jdbcracle:thin:@localhost:1521:xe
jdbc.username = username
jdbc.password = password

Exception
INFO: JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] starting to acquire jobs
Mar 23, 2012 5:36:43 PM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: Error while closing command context
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.VariableInstanceEntity.insertByteArray-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

Can you please provide the complete steps(step by step) to setup activiti on oracle DB.

[patelag]

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.

[trademak]

Please post your question only once.

[patelag]

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

[sunilkumartk]

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