public void getDataBySample(SampleHuman sampleHuman) throws LIMSRuntimeException {

    try {
      String sql = "from SampleHuman sh where samp_id = :param";
      Query query = HibernateUtil.getSession().createQuery(sql);
      query.setInteger("param", Integer.parseInt(sampleHuman.getSampleId()));
      List list = query.list();
      HibernateUtil.getSession().flush();
      HibernateUtil.getSession().clear();
      SampleHuman sh = null;
      if (list.size() > 0) {
        sh = (SampleHuman) list.get(0);
        PropertyUtils.copyProperties(sampleHuman, sh);
      }
    } catch (Exception e) {
      LogEvent.logError("SampleHumanDAOImpl", "getDataBySample()", e.toString());
      throw new LIMSRuntimeException("Error in SampleHuman getDataBySample()", e);
    }
  }