How to implement Primefaces TreeTable - Selection (CheckboxTreeNode) in Axon Ivy 7.0.1?

wesing — Fri, 27 Jul 2018 03:19:19 -0400

Hi,

I have tried to implement Primefaces TreeTable - Selection (CheckboxTreeNode) The sample code are obtained from https://www.primefaces.org/showcase/ui/data/treetable/selection.xhtml . In Axon Ivy 7.0.1 but it keeps getting the following error when I tried to navigate the tree.

ELException: Cannot convert [[Lorg.primefaces.model.TreeNode;@7d8d3a6a] of type [class [Lorg.primefaces.model.TreeNode;] to [class org.primefaces.model.CheckboxTreeNode]
    ContextAwareELException: javax.el.ELException: Cannot convert [[Lorg.primefaces.model.TreeNode;@7d8d3a6a] of type [class [Lorg.primefaces.model.TreeNode;] to [class org.primefaces.model.CheckboxTreeNode]
    Error during rendering of html dialog 'trial.TreeDataTryOut'

I did some googlings and someone suggested that it is due to PrimeFaces JAR files conflict. I have no idea how to resolve that in Axon Ivy. Could you help?

Also, it would be great if there are sample Axon Ivy projects with TreeDataTable - Checkbox for reference?

How to access database in a faces Validator

wesing — Mon, 23 Jul 2018 23:32:38 -0400

Hi all, I am new to AXON IVY. Hope you can be patient with me.

I am trying to use that code here: https://answers.axonivy.com/questions/314/using-db-connection-from-pis (provided by Ivy Support Team) in a Java class in a CustomValidator class to look up a database table. Somehow I could not resolve the Ivy object.

I tried looking up getProcessEngineHook method in https://developer.axonivy.com/doc/latest/PublicAPI but the search doesn't return any results.

My codes as follows:

package trial.facesValidation;
import javax.faces.application.FacesMessage;
import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.FacesValidator;
import javax.faces.validator.Validator;
import javax.faces.validator.ValidatorException;
import  java.sql.Connection;

// To validate if Item Name already existed in Parts table in Database
@FacesValidator("trial.facesValidation.CustomItemValidator")
public class CustomItemValidator implements Validator {

    @Override
    public void validate(FacesContext context, UIComponent component, Object value) throws ValidatorException 
    {
        //connect to the database
        Connection dbconnection = ivy.getProcessEngineHook().getDbConnection("TrialDBConn");

        try
        {
        // execute some sql queries
        } finally {
        // close the connection
              dbconnection.close();
        }

Questions asked by wesing

How to implement Primefaces TreeTable - Selection (CheckboxTreeNode) in Axon Ivy 7.0.1?

How to access database in a faces Validator