topic Re: Possible to store data in a step? in Alfresco Archive

Possible to store data in a step?

agiledevpro — Mon, 21 Jul 2014 10:43:50 GMT

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

Re: Possible to store data in a step?

agiledevpro — Wed, 23 Jul 2014 12:30:17 GMT

Re: Possible to store data in a step?

chittaranjan168 — Wed, 23 Jul 2014 12:36:54 GMT

Use ScriptTask in your process.and write

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

Re: Possible to store data in a step?

agiledevpro — Wed, 23 Jul 2014 12:39:07 GMT

Thank you!

Re: Possible to store data in a step?

agiledevpro — Thu, 24 Jul 2014 07:02:50 GMT

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!!

Re: Possible to store data in a step?

agiledevpro — Thu, 24 Jul 2014 07:29:39 GMT

Anyone?

Re: Possible to store data in a step?

jbarrez — Fri, 25 Jul 2014 08:31:48 GMT

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.

Re: Possible to store data in a step?

agiledevpro — Fri, 25 Jul 2014 08:37:31 GMT

Hi,

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

Regards

Re: Possible to store data in a step?

agiledevpro — Fri, 25 Jul 2014 12:03:50 GMT

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

Re: Possible to store data in a step?

sahusunil — Tue, 29 Jul 2014 04:22:13 GMT

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

Re: Possible to store data in a step?

agiledevpro — Wed, 13 Aug 2014 06:17:55 GMT

Re: Possible to store data in a step?

agiledevpro — Wed, 13 Aug 2014 06:29:31 GMT

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,

Re: Possible to store data in a step?

agiledevpro — Fri, 15 Aug 2014 06:07:19 GMT

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