topic Accessing activiti database tables from java code in Alfresco Archive

Accessing activiti database tables from java code

firzhan — Tue, 16 Sep 2014 19:07:28 GMT

How can I access the activiti database tables by using custom java code ?

Re: Accessing activiti database tables from java code

martin_grofcik — Wed, 17 Sep 2014 04:32:33 GMT

Hi Firzhan,

You can use the same DB connection settings and connect to the any DB (activiti too).

Regards
Martin

Re: Accessing activiti database tables from java code

firzhan — Wed, 17 Sep 2014 04:42:48 GMT

Hi Martin,

Thanks for your prompt response.

My requirement is to store the BPMN package name with the check-sum value in the activiti DB. By doing so I can avoid users uploading same packages in to the system.

I am planning to use a separate new table in the activiti DB for this task. I am running activiti from a java server.

My question is how can I insert the above mentioned values in to the table by using activiti engine without having external connection with the activiti DB?

Thanks in advance

Re: Accessing activiti database tables from java code

jbarrez — Wed, 17 Sep 2014 11:10:17 GMT

You can get access tot he connection through the DbSqlSession.getSqlSession() object, that one has the current connection.

Re: Accessing activiti database tables from java code

firzhan — Wed, 17 Sep 2014 12:23:48 GMT

Hi jbarrez,

Where can I find a sample to go through on accessing the connection using DbSqlSession.getSqlSession() object.

Any help or reference materials are appreciated

Re: Accessing activiti database tables from java code

trademak — Thu, 18 Sep 2014 14:06:23 GMT

Hi Firzhan,

You can look at the implementation of the org.activiti.engine.impl.cmd.ExecuteCustomSqlCmd class for a good example.
For custom SQL you can also use the ManagementService executeCustomSql method.

Best regards,