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.

record of database as input for workflow

striker_sfc1

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.

thanks
Alex

Find more posts tagged with

Comments

meyerd

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.

striker_sfc1

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

meyerd

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

meyerd

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

striker_sfc1

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

Alex

striker_sfc1

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

ronald_van_kuij

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

striker_sfc1

I resolve the first problem… but not the second.

ronald_van_kuij

Look at the CDI chapter…

striker_sfc1

I cannot resolve…. I try this:

<br>&hellip;<br>&hellip;..<br>ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration().buildProcessEngine();<br>RuntimeService runtimeService = processEngine.getRuntimeService();<br>runtimeService.startProcessInstanceByKey("wf2");<br><br>

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<br>Grave: Error while closing command context<br>org.activiti.engine.ActivitiException: no processes deployed with key 'wf2'<br> at org.activiti.engine.impl.persistence.deploy.DeploymentCache.findDeployedLatestProcessDefinitionByKey(DeploymentCache.java:63)<br> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:58)<br> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:31)<br> at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)<br> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)<br> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<br> at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:46)<br> at main.main(main.java:87)

ronald_van_kuij

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

striker_sfc1

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.

We do not all genes dear ronald.van.kuijk

ronald_van_kuij

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…

striker_sfc1

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

ronald_van_kuij

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…