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.