nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Possible to store data in a step?

agiledevpro

Hi,

I'm using an external database (mysql) instead of the default database. And I wonder if it is possible to insert data into my database in a step of a process?

The data is received from a java class and I want this data to be inserted through a step in my bpmn20.xml file.

If this is possible, could I be given some example code of how this can be done?

Thanks in advance!

Find more posts tagged with

Comments

agiledevpro

chittaranjan168

Use ScriptTask in your process.and write

importPackage(java.sql);
importPackage(java.lang);
importPackage(org.activiti.explorer.reporting);
ReportingUtil.executeSelectSqlQuery("insert query");

agiledevpro

Thank you!

agiledevpro

I've added my script to my process definition now but when I run the code I get an error saying:
javax.script.ScriptException: sun.org.mozilla.javascript.internal.EcmaError: ReferenceError: "ReportingUtil" is not defined.

This is the script:


               importPackage(java.sql);
               importPackage(java.lang);
               importPackage(org.activiti.explorer.reporting);

      ReportingUtil.executeSelectSqlQuery("insert into risk values ('123', 'someuser@gmail.com', 'Y')");

How can I make "ReportingUtil" defined?

Thank you!!

risk.bpmn20.xml_.txt.zip

agiledevpro

Anyone?

jbarrez

Wait - the response is not correct. Why would you want to use ReportingUtil to write data???

> The data is received from a java class and I want this data to be inserted through a step in my bpmn20.xml file.

runtimeService.setVariable() is the method your looking for.

agiledevpro

Hi,

It works now, I used ReportingUtil.getCurrentDatabaseConnection().prepareStatement("INSERT ..)

Regards

agiledevpro

The only question I now have is how to set my variables in the script?

…
               var p = ReportingUtil.getCurrentDatabaseConnection().prepareStatement("INSERT INTO risk VALUES (?, ?, ?)");

I know that the followning isn't possible:
               p.setString(1, ${id});
               p.setString(2, ${sender});
               p.setString(3, ${answer});
…

But I need something similar, because I want to set these ${..} in my java code.
Any suggestion on how this can be done?

Thanks

sahusunil

If you are using scriptTask, these variables can be accessed as process instance variable from your service task. If you are not able to access it, add activiti:autoStoreVariables="true" in your scriptTask tag and through DelegateExecution object in your java class, you should be able to access these values.

Thanks

agiledevpro

Hi, thank you for your answer.

You said that "…as process instance variable from your service task", did you mean script task?
Maybe I was unclear in my question.

What I want to do is when I reach the scriptTask in my process I want to insert values into the database. The values to be inserted is received from an email which I've read in a Java class and it is these values that I want to insert as soon as the execution is at my scriptTask.

From my java class I want to do something like:
Execution execution = runtimeService.createExecutionQuery()
.processInstanceId(pi.getId())
.activityId("ScriptState")
.singleResult();
runtimeService.signal(execution.getId(), varToInsert);

And in my scriptTask i need something like:
importPackage(java.sql);
importPackage(java.lang);
importPackage(org.activiti.explorer.reporting);

var p = ReportingUtil.getCurrentDatabaseConnection().prepareStatement("INSERT INTO risk VALUES (?, ?, ?)");

p.setString(1, ${id});
p.setString(2, ${name});
p.setString(3, ${answer]);
p.executeUpdate();
…

Anyone?

Regards,

agiledevpro

Problem is now solved.

The problem was solved by setting the variables in the step above my scipttask and then I could use these variables in my scripttask.

activiti:in source="uuid" target="${uuid}"
…

extensionElements
receiveTask

<scriptTask id="storeValues" name="Execute script" scriptFormat="JavaScript" activiti:autoStoreVariables="false">

          <script><![CDATA[

               importPackage(java.sql);
               importPackage(java.lang);
               importPackage(org.activiti.explorer.reporting);

               var p = ReportingUtil.getCurrentDatabaseConnection().prepareStatement("INSERT INTO risk VALUES (?, ?, ?)");
               var id = uuid;
               var sender = user;
               var answer = ans;

Regards,
Alexandra