propComponentID = addProperty(PROP_COMPONENT_ID, componentID, new ConfigurableComponentPropertyAdapter() { public void PropertyValueChanged(PropertyEvent e) { } });
  public void initProperties() {    String componentID = new String("");    String componentCategory = new String("");    StringBuffer assemblyMatch = null;    try {      initDBProperties();      assemblyMatch = new StringBuffer();      assemblyMatch.append("in (");      Iterator iter = assemblyID.iterator();      boolean first = true;      while (iter.hasNext()) {	String val = (String)iter.next();	if (first) {	  first = false;	} else {	  assemblyMatch.append(", ");	}	assemblyMatch.append("'");	assemblyMatch.append(val);	assemblyMatch.append("'");      }      assemblyMatch.append(")");      substitutions.put(":assemblyMatch", assemblyMatch.toString());      substitutions.put(":component_name", name);    } catch(IOException e) {      throw new RuntimeException("Error: " + e);    }    try {      Connection conn = DBUtils.getConnection();      try {	Statement stmt = conn.createStatement();	String query = dbp.getQuery(QUERY_AGENT_DATA, substitutions);	ResultSet rs = stmt.executeQuery(query);	while(rs.next()) {	  componentID = getNonNullString(rs, 1, query);	  componentCategory = getNonNullString(rs, 2, query);	}      } finally {	conn.close();      }    } catch (Exception e) {      e.printStackTrace();      throw new RuntimeException("Error" + e);    }    propName = addProperty(PROP_AGENT_NAME, name,			   new ConfigurableComponentPropertyAdapter() {			     public void PropertyValueChanged(PropertyEvent e) {			     }			   });    propComponentID = addProperty(PROP_COMPONENT_ID, componentID,			   new ConfigurableComponentPropertyAdapter() {			     public void PropertyValueChanged(PropertyEvent e) {			     }			   });    propCategory = addProperty(PROP_COMPONENT_CATEGORY, componentCategory,			   new ConfigurableComponentPropertyAdapter() {			     public void PropertyValueChanged(PropertyEvent e) {			     }			   });  }