activiti stop working when refresh datasource with new properties

[shivam-ver]

Hi,

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.

repositoryService.createDeployementQuery().list().

ERROR-Stack

SQLSERVEREXCEPTION: 

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.

[shivam-ver]

Hi Greg Harley‌,

Thanks for a reply.

Have you get a chance to look at  - re-initializing the process engine with the new DB properties at runTime as you highLight in your above comments.

Please let me know if any work around. 

Thanks.

[shivam-ver]

Hi Greg Harley,

Thanks for a reply.

Question :

have one question regarding creating activiti database.

I don't want start activiti on server startup.

I want activiti only start when user fill up the Html form with new database properties and click on save button at runtime.

Have you get a chance to look at  - re-initializing the process engine with the new DB properties at runTime as you highLight in your above comments. 

Please let me know if any work around. 

Thanks.

[gdharley]

Hi Shivam,

I have not and am not planning on looking into what would be required to re-initialize the process engine configuration at runtime. I offered the details so that you can look into this yourself should you desire.

Greg