AnsweredAssumed Answered

How to configure activiti on oracle database

Question asked by mihirdas on Mar 23, 2012
Latest reply on Apr 27, 2016 by sunilkumartk
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=jdbc:oracle: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.

Outcomes