Accessing activiti database tables from java code

[firzhan]

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

[martin_grofcik]

Hi Firzhan,

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

Regards
Martin

[firzhan]

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

[jbarrez]

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

[firzhan]

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

[trademak]

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,