topic constraint error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279444#M232574 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm trying to create a list to access a table in a database and II have found that does not work.</SPAN><BR /><SPAN>Step as I have done everything step by step</SPAN><BR /><BR /><SPAN>First I have created a class and have exported. jar and put it in webapps/alfresco/WEB-INF/lib</SPAN><BR /><SPAN>in case you missed the access to the database I have done a simulation manually adding items to the list</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />package com.tecnausa.meconecto;<BR />import java.io.Serializable;<BR />import java.sql.Connection;<BR />import java.sql.DriverManager;<BR />import java.sql.ResultSet;<BR />import java.sql.Statement;<BR />import java.util.ArrayList;<BR /><BR />import java.util.List;<BR />import javax.faces.model.SelectItem;<BR />import org.alfresco.repo.dictionary.constraint.ListOfValuesConstraint;<BR />import org.alfresco.web.bean.generator.BaseComponentGenerator;<BR />import org.apache.commons.logging.Log;<BR />import org.apache.commons.logging.LogFactory;<BR />public class ListOfValuesQueryConstraint extends ListOfValuesConstraint implements Serializable{<BR /><BR />&nbsp;&nbsp;&nbsp;@SuppressWarnings("unused")<BR />&nbsp;&nbsp;&nbsp;private static Log logger = LogFactory.getLog(BaseComponentGenerator.class);<BR />&nbsp;&nbsp;&nbsp;private static final long serialVersionUID=1;<BR />&nbsp;&nbsp;&nbsp;private List&lt;String&gt; allowedLabels;<BR />&nbsp;&nbsp;&nbsp;@SuppressWarnings("unchecked")<BR />&nbsp;&nbsp;&nbsp;public void setAllowedValues(List allowedValues) {}<BR />&nbsp;&nbsp;&nbsp;public void setCaseSensitive(boolean caseSensitive) {}<BR />&nbsp;&nbsp;&nbsp;public void initialize() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; super.setCaseSensitive(false);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.loadDB(); <BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;public List&lt;String&gt; getAllowedLabels() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return this.allowedLabels;<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;public void setAllowedLabels(List&lt;String&gt; allowedLabels) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.allowedLabels=allowedLabels;<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;public List&lt;SelectItem&gt; getSelectItemList() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;SelectItem&gt; result = new ArrayList&lt;SelectItem&gt;(this.getAllowedValues().size());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(int i=0;i&lt;this.getAllowedValues().size();i++) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result.add(new SelectItem((Object)this.getAllowedValues().get(i),this.allowedLabels.get(i)));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return result;<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp; protected void loadDB() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /*<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String driverName = "org.postgresql.Driver";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String serverName = "localhost";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String mydatabase = "alfresco";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String username = "alfresco";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String password = "admin";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String port = "5432";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;String&gt; av = new ArrayList&lt;String&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;String&gt; al=new ArrayList&lt;String&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; av.add("av1");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; av.add("av2");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; av.add("av3");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /*<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Connection connection = null;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Class.forName(driverName);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String url = "jdbcsmileyostgresql://" + serverName + ":"+ port + "/" + mydatabase;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connection = DriverManager.getConnection(url, username, password);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Statement stmt = connection.createStatement();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet rs = stmt.executeQuery("select mi_id from t_equipos"smiley;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; while (rs.next()) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; av.add(rs.getString("JMBG"smiley);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; catch (Exception e) {}<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; */<BR />&nbsp;&nbsp;&nbsp; }<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>later, I based in share-sample-DataLists for me here on my own I got it </SPAN><A href="http://code.google.com/p/share-extras/wiki/DataLists" rel="nofollow noopener noreferrer">http://code.google.com/p/share-extras/wiki/DataLists</A><BR /><SPAN>Basically what I have done is unzip the. jar and re-tune it compressed into jar, so that has been so</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />……<BR />&lt;constraints&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;constraint name="dlexample:l01" type="LIST"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter name="allowedValues"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;Equipo de red&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;Impresora&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;Ordenador PC&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/constraint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;constraint name="dlexample:l02" type="com.tecnausa.meconecto.ListOfValuesQueryConstraint"&gt;&lt;/constraint&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/constraints&gt;<BR />&nbsp;&nbsp; &lt;types&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type name="dlexample:book"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ….<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dlexample:lista1"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;title&gt;lista1&lt;/title&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type&gt;d:text&lt;/type&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;constraints&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;constraint ref="dlexample:l01" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/constraints&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ….<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>when I change the line &lt;constraint ref="dlexample:l01" /"&gt; by &lt;"constraint ref =" dlexample: l02 "/&gt;</SPAN><BR /><SPAN>alfresco completely stops working</SPAN><BR /><BR /><SPAN>sorry for my english, is terribly wrong</SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Mon, 18 Feb 2013 09:11:13 GMT lazaro 2013-02-18T09:11:13Z constraint error https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279444#M232574 Hi, I'm trying to create a list to access a table in a database and II have found that does not work.Step as I have done everything step by stepFirst I have created a class and have exported. jar and put it in webapps/alfresco/WEB-INF/libin case you missed the access to the database I have done a si Mon, 18 Feb 2013 09:11:13 GMT https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279444#M232574 lazaro 2013-02-18T09:11:13Z Re: constraint error https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279445#M232575 <HTML><HEAD></HEAD><BODY><SPAN>what is the error you are getting in your logs?</SPAN><BR /><SPAN>Is it calling your class first make sure that.</SPAN><BR /></BODY></HTML> Mon, 18 Feb 2013 10:56:35 GMT https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279445#M232575 mitpatoliya 2013-02-18T10:56:35Z Re: constraint error https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279446#M232576 <HTML><HEAD></HEAD><BODY><SPAN>sorry am a newbie in alfresco development and not where the log file.</SPAN><BR /><SPAN>I think calling the class because if I change the call "type = fail.fail.miclass" fails because it can not find it in WEB-INF/lib</SPAN><BR /><BR /><SPAN>I've also tried to do this</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;parameter name="allowedValues" type="com.tecnausa.meconecto.ListOfValuesQueryConstraint"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/parameter&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I've also edited directly datalistmodel.xml and share-datalist-form-config.xml but still giving me the error</SPAN><BR /><SPAN>Do I something is missing to do?</SPAN><BR /><SPAN>Could it be that the error is because export the. Jar directly without using ant?</SPAN><BR /><BR /><SPAN>thanks for replying</SPAN><BR /><SPAN>regards from Spain</SPAN></BODY></HTML> Mon, 18 Feb 2013 11:35:21 GMT https://connect.hyland.com/t5/alfresco-archive/constraint-error/m-p/279446#M232576 lazaro 2013-02-18T11:35:21Z