topic Re: Using External Databases with Activiti BPMN in Alfresco Archive

Using External Databases with Activiti BPMN

anu86 — Mon, 25 Jan 2016 12:10:32 GMT

I'm currently working with some business process creation using BPMN with Activiti. For one step in that business process I need to query a database and use that result in subsequent steps. So I'm looking for possible workarounds to integrate SQL operation capabilities to Activiti. So can anyone ple

Re: Using External Databases with Activiti BPMN

maudrid — Mon, 25 Jan 2016 13:14:44 GMT

I have not been using activity for a very long time, but my suggestion is to implement a new service task that connects to the external database.

I have a piece of code that I use to connect and creates a statement.
<code>
protected Statement createStatement(String dataSourceUrl, String dataSourceUsername, String dataSourcePassword){
     Connection conn = null;
Statement stmt = null;
     try {
         conn = DriverManager.getConnection(dataSourceUrl, dataSourceUsername, dataSourcePassword);
     } catch (SQLException e) {
      logger.error("Cannot get connection: " + e.getMessage());
         return null;
     }

     try {
         stmt = conn.createStatement();
     } catch (SQLException e) {
      logger.error("Cannot create statement: " + e.getMessage());
         return null;
     }
     return stmt;
    }
</code>

Re: Using External Databases with Activiti BPMN

anu86 — Mon, 25 Jan 2016 13:25:09 GMT

Thanks a lot for the suggestion. Java Service Task will be a good approach for my problem. I will look in to that. Thanks for the explanation