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 Tagged With database

How to access database in a faces Validator