cancel
Showing results for 
Search instead for 
Did you mean: 

Activiti Explorer with sql server

rutvi
Champ in-the-making
Champ in-the-making
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
1 REPLY 1

jbarrez
Star Contributor
Star Contributor
It should create the tables on first bootup. Did you change anything in the process engine config xml? Or the java config? Or just the defaults.