How to configure activiti on oracle database

4 posts / 0 new
Last post
mihirdas
Offline
Last seen: 1 year 12 months ago
Joined: 03/23/2012 - 14:04
Posts: 3
How to configure activiti on oracle database

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.

patelag
Offline
Last seen: 1 month 3 weeks ago
Joined: 02/17/2014 - 04:23
Posts: 14

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.

attachment: 
trademak
Offline
Last seen: 3 days 15 hours ago
Joined: 08/20/2010 - 21:12
Posts: 2501

Please post your question only once.

Tijs Rademakers
Project lead Activiti
Manning book website --> Activiti in Action
Follow me on Twitter (@tijsrademakers)

patelag
Offline
Last seen: 1 month 3 weeks ago
Joined: 02/17/2014 - 04:23
Posts: 14

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