AnsweredAssumed Answered

Activiti Explorer with sql server

Question asked by rutvi on Jun 14, 2016
Latest reply on Jun 20, 2016 by jbarrez
Hi,

I tried to configure activiti explorer with mssql. Which is throwing following exception on server start up.

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 querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ACT_GE_PROPERTY'.
### The error may exist in org/activiti/db/mapping/entity/Property.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ACT_GE_PROPERTY'.


Tables are not getting created in activiti database.

I did following things to configure mssql with activiti explorer
1. Add driver 'sqljdbc4-3.0.0.jar' to 'activiti-explorer/WEB-INF/lib'
2. Modified db.properties (Please find attached)
3. Modified activiti-custom-context.xml (Please find attached)

Please find 'catalina.out' attached for detailed logs

Thanks

Outcomes