https://answers.axonivy.com/questions/3364/how-to-access-database-in-a-faces-validator<p>Hi all, I am new to AXON IVY. Hope you can be patient with me.</p> <p>I am trying to use that code here: <a href="https://answers.axonivy.com/questions/314/using-db-connection-from-pis">https://answers.axonivy.com/questions/314/using-db-connection-from-pis</a> (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. </p> <p>I tried looking up getProcessEngineHook method in <a href="https://developer.axonivy.com/doc/latest/PublicAPI">https://developer.axonivy.com/doc/latest/PublicAPI</a> but the search doesn't return any results.</p> <p>My codes as follows:</p> <pre><code>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(); } </code></pre>enTue, 24 Jul 2018 09:14:35 -0400https://answers.axonivy.com/questions/3364/how-to-access-database-in-a-faces-validator/3365<p>I think the code above is outdated since Axon.ivy 6.0. </p> <p>But it should be possible to solve this problem by using JPA: <a href="https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.datamodeling.html#ivy-persistence-api">https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.datamodeling.html#ivy-persistence-api</a></p> <p>Then you could easily access the persistence unit or the EntityManager itself and query any objects out of the database. Similar as shown here: <a href="https://answers.axonivy.com/questions/1102/how-to-use-jpa-entity-manager-instead-of-ivy-entity-manager/1103">https://answers.axonivy.com/questions/1102/how-to-use-jpa-entity-manager-instead-of-ivy-entity-manager/1103</a></p> <p>The rough steps to use JPA in an ivy project:</p> <ol> <li>define an external database as data store: <a href="https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.configuration.html#ivy-database">https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.configuration.html#ivy-database</a></li> <li>map it to a persistence unit provider: <a href="https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.datamodeling.html#ivy-editors-persistence-configuration">https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.datamodeling.html#ivy-editors-persistence-configuration</a></li> <li>generate JPA pojos: <a href="https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.datamodeling.html#ivy-persistence-entityclasses">https://developer.axonivy.com/doc/latest/DesignerGuideHtml/ivy.datamodeling.html#ivy-persistence-entityclasses</a></li> </ol>Reguel WermelingerTue, 24 Jul 2018 09:14:35 -0400https://answers.axonivy.com/questions/3364/how-to-access-database-in-a-faces-validator/3365