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 a field injection

ibfgroupwork

hi,
i'm still a newbie with activiti and i have the following question:

how can i create a combobox that shows data from the database ?
ive been testing using a listener implementation but with no luck !!!!!!!!
please can someone help me with a full "how to "
i'll be so much greatful
thks in advance!!!!!!!!!!!!!

Find more posts tagged with

Comments

ronald_van_kuij

Do not try to do everything IN Activiti… Use a normal webapp for things as well and integrate activiti in it…

ibfgroupwork

thaks for your replay!!!!!!!!!!

i was hoping that i can use listeners or such !!!!
in fact i dont need to build a webapp , the activitiexplorer is already enough for me
all i have is simple processes and vary simple forms
the only concern is that i want to display data from my database (mysql) in a field within a form
i've been reading and searching in the forums and i've found that this could be done with an external java class called from a listener
only i dont know how to cordinate between the result of this given class and the field within the form???????????!!!!!

thank for any help !!!!!!!!!!

ibfgroupwork

hi,
i've managed to read a value from the database and display it in a form field

i've use a java service task with the following class:

public class aicha implements JavaDelegate {
public void execute(DelegateExecution execution) throws Exception {

try {
   Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
}
   Connection con;
   Statement stmt;

   try {


    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/activiti","root","a");
    System.out.println ("Ok, connection to the DB worked.");
    stmt = con.createStatement();
    String queryString1 = " select FIRST_ from act_id_user ";

    ResultSet rs = stmt.executeQuery(queryString1);
    while (rs.next()) {
      String name = rs.getString("FIRST_");
      execution.setVariable("nom",name);

     }



   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();

   }


//String nom = (String) execution.getVariable("nom");
//conn();
//execution.setVariable("nom",conn());

}
}

where nom is the id of the form's field in the process diagram.but i still have ine issue
how can' i display a collection of items from the database (combo box ) .i've tried to use the type "enum" but no results!!!!!!!

thanks for any reply