topic Re: activiti stop working when refresh datasource with new properties in Alfresco Forum

activiti stop working when refresh datasource with new properties

shivam-ver — Thu, 02 Mar 2017 11:48:20 GMT

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

Re: activiti stop working when refresh datasource with new properties

jearles — Thu, 02 Mar 2017 17:24:42 GMT

In your error:

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 ?

The word 'LIMIT' is spelled incorrectly. Could that be a part of the issue? Have you potentially misspelled the word?
Also in that same error, your spelling of 'LIMIT' is follow immediately by a question mark, which I believe is incorrect syntax, as there should be a space between them.

If these aren't the problem, could you please include the entire stacktrace?

-JEarles

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Thu, 02 Mar 2017 18:17:01 GMT

Thanks for your reply,

Please find my problem details as attached

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Thu, 02 Mar 2017 18:19:14 GMT

thanks for reply.

Please find my problem details as attached snapshot

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Fri, 03 Mar 2017 17:58:29 GMT

can anyone help me regarding this issue.

Re: activiti stop working when refresh datasource with new properties

jearles — Fri, 03 Mar 2017 18:41:37 GMT

Shivam,

It appears as thought you're using Microsoft SQL Server - is that correct? Which version of it are you using? I'm not sure if the newer versions support 'LIMIT' - but that hasn't previously been a support clause in the Microsoft SQL server dialect.

If this is custom SQL that you've written, you'll want to change it yourself.
If this is autogenerated SQL by the application, you'll want to take a look at your database configuration and verify that you have your dialect configured properly.

-JEarles

Re: activiti stop working when refresh datasource with new properties

sunilkumartk — Sun, 05 Mar 2017 15:43:13 GMT

Have you installed the Activiti Tables in your new database ?

You are expected to do that correctly

There are plenty of resources available online that helps you understand Activiti installation and configuration or try my Installation tutor heree

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Tue, 07 Mar 2017 15:43:00 GMT

Hi ,

Let me explain my scenario as below and please help me out.

Objective :I want to switch activiti database at runtime .Initially run on H2 database and when server up I show the simple html page to user where he/she can put new database information for switch their database.Supposed user need to switch from H2 to MSSQL database then he/she will fill all the required database information in the html form example:

databaseType=MSSQL ,databaseName ="newDatabase",UserName="username",password="password"

As per information I get from HTML form I create a DATASOURCE and set that datasource in processEngineConfiguration and refresh my activitiConfig file [this file is a

@configuration file in spring which run when i refresh the spring context.

]

and when I set updated datasource in processEngine and refresh activitiConfig.java file then all the activiti table get generated in new database successfully .

BUT my problem is -after refreshing the datasouce with new database then I am trying to deploy my .bpmn file in activiti but it is giving me some error as below.And I also attached one png which show the information after refresh the datasource with new value.

getting error when I execute java code : repositoryService.createDeploymentQuery.List()

‌ : I also checked MSSQL DIALECT but it is correct. Please see my snapshot for more information.

PLEASE see attached snapshot for more details as attached.

error:

Error during job acquisition

Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect Syntax 'LIMIT'.

The error may exist in org/activiti/db/mapping/entity/Job.xml

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Tue, 07 Mar 2017 16:02:58 GMT

Hi ,

Let me explain my scenario as below and please help me out.

databaseType=MSSQL ,databaseName ="newDatabase",UserName="username",password="password"

As per information I get from HTML form I create a DATASOURCE and set that datasource in processEngineConfiguration and refresh my activitiConfig file [this file is a

@configuration file in spring which run when i refresh the spring context.

]

and when I set updated datasource in processEngine and refresh activitiConfig.java file then all the activiti table get generated in new database successfully .

getting error when I execute java code : repositoryService.createDeploymentQuery.List()

Jonathan Earles : I also checked MSSQL DIALECT but it is correct. Please see my snapshot for more information.

PLEASE see attached snapshot for more details as attached.

error:

Error during job acquisition

Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect Syntax 'LIMIT'.

The error may exist in org/activiti/db/mapping/entity/Job.xml

Re: activiti stop working when refresh datasource with new properties

gdharley — Tue, 07 Mar 2017 17:59:53 GMT

"I want to switch activiti database at runtime .Initially run on H2 database and when server up I show the simple html page to user where he/she can put new database information for switch their database"

There is no easy way to do this.
The dbSqlSession is stored as a session object within the ProcessEngineConfiguration.

This effectively makes it a singleton.

As far as I am aware, there is no easy way to override the sqlSession at runtime.

Obviously, this is just software and if you wanted to implement such behavior, I would look at re-initializing the process engine with the new DB properties.

Now, I'm not sure why you want to do this, but there is a tenant aware process engine configuration that is documented here:

Multi-Tenancy with separate database schemas in Activiti | Small steps with big feet

If this doesnt satisfy your need, then it may be a good start on how to implement your desied behavior.

Greg

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Wed, 08 Mar 2017 07:44:13 GMT

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.

Re: activiti stop working when refresh datasource with new properties

shivam-ver — Wed, 08 Mar 2017 07:50:49 GMT

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.

Re: activiti stop working when refresh datasource with new properties

gdharley — Wed, 08 Mar 2017 12:59:39 GMT

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