topic Re: record of database as input for workflow in Alfresco Archive

record of database as input for workflow

striker_sfc1 — Wed, 28 Mar 2012 15:53:23 GMT

Hi people.I have a table in my postgresql DB. I need of read records from the database and use some fields as input to start a workflow.At the moment I can read the input parameters from a form (for testing the workflow), but i need of automate the process reading those parameters from a DB.thanksAl

Re: record of database as input for workflow

meyerd — Wed, 28 Mar 2012 16:03:20 GMT

Hi striker_sfc,

Just write some Java Classes that read these items of Data from the Database and pass them to the process instance when stating the process.

Re: record of database as input for workflow

striker_sfc1 — Wed, 28 Mar 2012 16:16:49 GMT

We suppose that i have a dbconnection in a java class and I had read the fields that I need and I store it in the following variables:

String name = resultSet.getString("DB_name");
String surname = resultSet.getString("DB_surname");
String role = resultSet.getString("DB_role");

and now i need of start a instance of my workflow called "myWorkflow" with those parameters as input.

Can you write for me the sting that pass the variables to my workflow instance and launch it?

thanks for the quickly reply.
Alex

Re: record of database as input for workflow

meyerd — Wed, 28 Mar 2012 16:30:14 GMT

Hi striker_sfc,

Just put you data in a java.util.Map:

Map<String, Object> processVariables = new HashMap<String, Object>();
processVariables.put("name", name);
processVariables.put("surname", surname);
…

runtimeService.startProcessInstanceByKey("myWorkflow", processVariables);

In the bpmn20.xml you can then reference the vaiables using ${name}, ${surname} and so forth

Re: record of database as input for workflow

meyerd — Wed, 28 Mar 2012 16:31:26 GMT

http://activiti.org/userguide/index.html#10minutetutorial

Re: record of database as input for workflow

striker_sfc1 — Wed, 28 Mar 2012 16:36:27 GMT

Perfect! I will test it soon…
Thanks a lot for your help!

Alex

Re: record of database as input for workflow

striker_sfc1 — Wed, 28 Mar 2012 17:10:02 GMT

I test your solution and…

1) I must use HashMap<String, Object> processVariables = new HashMap<String,Object>();

because if i use Map<String, Object> processVariables = new HashMap<String,Object>() i have this error:

" Type mismatch: cannot convert from HashMap<String,Object> to Iterators.Map<String,Object> "

2) I have a problem on ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("wf1", processVariables) :
" runtimeService cannot be resolved "

infact eclipse with ctrl+space give me RuntimeService (interface of org.activi.engine)
but if I use
ProcessInstance processInstance = RuntimeService.startProcessInstanceByKey("wf1", processVariables)

eclipse said

The method startProcessInstanceByKey(String, String) in the type RuntimeService is not applicable for the arguments (String, Iterators.Map<String,Object>)

Re: record of database as input for workflow

ronald_van_kuij — Wed, 28 Mar 2012 17:14:33 GMT

1: learn java
2a: see 1
2b: read the manual, look at examples,

Re: record of database as input for workflow

striker_sfc1 — Wed, 28 Mar 2012 17:25:23 GMT

I resolve the first problem… but not the second.

Re: record of database as input for workflow

ronald_van_kuij — Wed, 28 Mar 2012 19:03:00 GMT

Look at the CDI chapter…

Re: record of database as input for workflow

striker_sfc1 — Thu, 29 Mar 2012 16:08:51 GMT

I cannot resolve…. I try this:


…
…..
ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration().buildProcessEngine();
RuntimeService runtimeService = processEngine.getRuntimeService();
runtimeService.startProcessInstanceByKey("wf2");

But at line runtimeService.startProcessInstanceByKey("wf2"); it give me this error:

mar 29, 2012 6:05:25 PM org.activiti.engine.impl.interceptor.CommandContext close
Grave: Error while closing command context
org.activiti.engine.ActivitiException: no processes deployed with key 'wf2'
 at org.activiti.engine.impl.persistence.deploy.DeploymentCache.findDeployedLatestProcessDefinitionByKey(DeploymentCache.java:63)
 at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:58)
 at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:31)
 at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
 at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:46)
 at main.main(main.java:87)

Re: record of database as input for workflow

ronald_van_kuij — Thu, 29 Mar 2012 17:20:39 GMT

New questions in new topics… And search the forum and the internet please… Very generic issue…

Re: record of database as input for workflow

striker_sfc1 — Fri, 30 Mar 2012 09:06:27 GMT

I don't understand because you are very irritating! I searched for this issue in internet all day and i don't find nothig… and also.. The problem is the same as the initial of this topic!

If you do not want to answer … do not!

Alex

P.S. I resolved the problem: I had insert a wrong wf name. :lol: We do not all genes dear ronald.van.kuijk

Re: record of database as input for workflow

ronald_van_kuij — Fri, 30 Mar 2012 10:46:23 GMT

I don't understand because you are very irritating!

It's up to you… just do not expect any help from me from now on… Never, ever…

http://catb.org/~esr/faqs/smart-questions.html#not_losing

Have a nice weekend…

Re: record of database as input for workflow

striker_sfc1 — Fri, 30 Mar 2012 10:50:13 GMT

so far did not help me. you only have offended..so….

Re: record of database as input for workflow

ronald_van_kuij — Fri, 30 Mar 2012 11:40:37 GMT

Offended? Most of your questions were basic java things… Therefor the answer: learn java and a references to e.g. CDI.

Your second question was not in any way related to the topic… Yes for your 'local' challenge' but not for others. If they search for something related to your second question, they see a topic that is in not any way related. So therefor I responded with: new questions in new topics.

I do not see how in anyway this could have offended you… In my opinion, you made it personal by calling me irritating… I never ever used words like that.

But again… It's your choice…