[jboss-user] [jBPM] - Getting information from another Database

[Sadiroveski S]

Sadiroveski S [https://community.jboss.org/people/sadiroveski] created the discussion

"Getting information from another Database"

To view the discussion, visit: https://community.jboss.org/message/795900#795900

--------------------------------------------------------------
Hello,

I am trying to get information from a Production Database to display them in the form. For example, the employee wants to create a new customer, he will run the process and add a new customer and select the country from a Combo Box (The combo box here is filled in information from the database) then the selected country will be assigned to the process variables.

Conceptually, I am thinking of 2 approaches:

* Getting information from a Production Database (Approach 1):* Specific task will connect to a database to capture all information
* The task will assign the values to the process
* The next Form task will get the information from the Process to present them in the form controls (Example: Combo Box)

This approach will cause to save information to the process in every created process instance. There could be a lot of info, i.e. available counties, available products to sell, registered customers……
* Getting information from a Production database (Approach 2):* Customize the form controls to access the database to read the information and put them in Form controls.
* There is no need to create a task to connect to the database and save all information on the process variables or even task variables.

This approach could not be implemented since the form is built using Freemarker(FTL Files) which is not like JSP where we can’t mix code with HTML. Is there a way to create an object and read from it using FTL?

Regards,
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/795900#795900]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130204/46a3a036/attachment.html