AnsweredAssumed Answered

activiti stop working when refresh datasource with new properties

Question asked by shivam-ver on Mar 2, 2017
Latest reply on Mar 8, 2017 by gdharley



I am facing problem when we refresh the datasource in activiti. 


Initially I set my datasource from properties file on H2 and after server up I show one simple page where I ask for new datasource properties  then refresh our application datasource with new new properties bbut activiti stop working and throwing error as below.



getting exception on  java code as below.







Error may exist in org/activiti/db/mapping/entity/deployment.xml

Error involved in  org.activiti.engine.impl.persistence.entity.deploymentEntity.SelectDeploymentByQueryCriteria-inline

setting parameters * from ACT_re_deployment RES order by RES.ID asc LIMT? OFFSET ?


Cause: SQLSERVEREXCEPTION : Incorrect syntax near 'LIMIT'


PLEASE I spend lot of days on this issue.