public ArrayList findAllActiveByCRF(CRFBean crf) { HashMap variables = new HashMap(); this.setTypesExpected(); this.setTypeExpected(14, TypeNames.INT); // crf_version_id this.setTypeExpected(15, TypeNames.STRING); // version name variables.put(new Integer(1), new Integer(crf.getId())); String sql = digester.getQuery("findAllActiveByCRF"); ArrayList alist = this.select(sql, variables); ArrayList al = new ArrayList(); Iterator it = alist.iterator(); while (it.hasNext()) { HashMap hm = (HashMap) it.next(); ItemBean eb = (ItemBean) this.getEntityFromHashMap(hm); Integer versionId = (Integer) hm.get("crf_version_id"); String versionName = (String) hm.get("cvname"); ItemFormMetadataBean imf = new ItemFormMetadataBean(); imf.setCrfVersionName(versionName); // logger.info("versionName" + imf.getCrfVersionName()); imf.setCrfVersionId(versionId.intValue()); eb.setItemMeta(imf); al.add(eb); } return al; }