How to configure activiti on oracle database

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

activity-context.txt.zip